|
How to apply a filter to a Pivot Table with a macro?
|
|
3
|
210
|
April 18, 2024
|
|
Problem when refreshing pivot tables
|
|
3
|
123
|
April 16, 2024
|
|
Pivot Table to count instances IF a condition met
|
|
7
|
157
|
March 14, 2024
|
|
Pivot table - how to show total at the end of the groupped month and add additional columns with caluclations?
|
|
2
|
220
|
March 6, 2024
|
|
Calc GETPIVOTDATA through macro
|
|
20
|
1006
|
April 23, 2023
|
|
How to keep color scale formating of pivot table on refresh in calc?
|
|
17
|
1957
|
March 2, 2023
|
|
Pivot Table Grouped by Financial Year
|
|
11
|
853
|
February 15, 2023
|
|
How to Group By Month and Year with Subtotals in Pivot Table?
|
|
5
|
11674
|
February 8, 2023
|
|
How to properly filter by date in a pivot table?
|
|
5
|
1625
|
January 26, 2023
|
|
Chart from pivot table using date on x-axis differs from one from standard table
|
|
0
|
230
|
January 25, 2023
|
|
Formating numbers for Pivot Tables based on external datasources (external databases)
|
|
10
|
850
|
January 10, 2023
|
|
Language agnostic MATCH? Pivot with different locales
|
|
3
|
509
|
January 3, 2023
|
|
Formattazione tabella pivot con stili diversi
|
|
1
|
526
|
August 9, 2022
|
|
Use alternative quarter name
|
|
1
|
375
|
August 2, 2022
|
|
Update All Pivot Tables When Opening File In ODS Format?
|
|
10
|
918
|
May 29, 2022
|
|
How to create automatically updating column, which aggregates data from other sheets?
|
|
12
|
2007
|
March 21, 2022
|
|
How to group chuncks of time seperated by a minimum of 30 mins-Pivot Table
|
|
12
|
1500
|
March 15, 2022
|
|
Pivot table cells lose format when refreshed
|
|
8
|
1083
|
March 2, 2022
|
|
Pivot table doesn't show totals
|
|
2
|
1016
|
January 31, 2022
|
|
Workaround for flawed XY (Scatter) pivot charts!
|
|
1
|
1628
|
December 27, 2021
|
|
Pivot Table/Chart: How to enforce linear X axis pace across skipped rows?
|
|
4
|
1074
|
December 25, 2021
|
|
Automate Pivot Table Data > Graph
|
|
4
|
642
|
December 25, 2021
|
|
Can a pivot table data field name be customised?
|
|
7
|
1943
|
November 19, 2021
|
|
How do I retrieve a unique list of items from a PivotTable field?
|
|
12
|
1022
|
November 4, 2021
|
|
Area dati di una pivot
|
|
0
|
364
|
November 2, 2021
|
|
Guidance for newbie on summarizing data in Calc: pivot table or custom macros?
|
|
3
|
651
|
August 30, 2021
|
|
How to aggregate rows using group by?
|
|
3
|
25739
|
June 28, 2021
|
|
How to subset a spreadsheet by month (for any year) when column 1 contains dates
|
|
2
|
763
|
June 3, 2021
|
|
Calc - Pivot Table - arrange columnar data from multiple rows into one row
|
|
2
|
2211
|
April 8, 2021
|
|
Calc Pivot Table % of Total Display Value Setting not getting saved
|
|
5
|
579
|
March 31, 2021
|
