Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table - display filtered data
I have a pivot table chart. The user can drag and drop field buttons to
'drill' into the data. The user can also filter the field buttons. I want to give the user an option to display all the values of a certain field, based on the filtering of the other fields. I can use the '.PivotItems(1)', '.PivotItems(2)' properties to list every item for that pivot field. But how do I retrieve just the values for my field based on the filters of the other fields? I hope this makes sense - thanks in advance for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i get a sum of the data filtered in a pivot table | Excel Discussion (Misc queries) | |||
Pivot Table doesn't display all data | Excel Discussion (Misc queries) | |||
Using Pivot Table to Display Filtered Data Only | Excel Discussion (Misc queries) | |||
Pivot Table: Display data | Setting up and Configuration of Excel | |||
how to display specific data in a Pivot Table | Excel Programming |