Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing data in a Pivot table
I have a pivot table with columns as months, rows as product codes, and the
body of the table in $ amounts. I want to sum a range of month, eg: Jun 06 to May 07. How can I do this? I don't want to use absolute column references as month change location as more/less data is added to the pivot table. Getpivotdata doesn't seem easy to nest in another formulas. Any suggestions? Many thanks -- Peter London, UK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summing function in pivot table in column wise ?? | Excel Worksheet Functions | |||
Total Not Summing Correctly on Calculated Fields in Pivot Table | Excel Discussion (Misc queries) | |||
pivot table column summing | Excel Discussion (Misc queries) | |||
summing values in a data table based on criteria in another column | Excel Worksheet Functions | |||
pivot table column summing | Excel Discussion (Misc queries) |