Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Filtering within Pivot Tables
Is it possible to filter the data going in to the pivot tables automatically?
For instance I want to look at the results of a calculation for the last 3 years of data out of 10 years worth of data. I need to look at the weighted average these three years. I can filter the data, then copy it to a new worksheet and finally bring it in to the pivot table but this is rather a pain and I would like to look at many different combinations of filters. I look forward to hearing from everyone. Have a great day, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
overlapping pivot tables | Excel Discussion (Misc queries) | |||
Pivot Tables filtering data | Excel Discussion (Misc queries) | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |