Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a fantastic pivot table that I built that I use to answer questions
from by customers. However, the questions are often varied and I find it difficult to easily select and de-select data. Is there a way to filter the page fields in a pivot table. For example, I might need to go from seeing all the data for one plant to the data for one material at all the plants. I have over a thousand materials, over a hundred plants. So, going from one set to data to the other is taking some time because I have to select and de-select so many individual items. I would really like to add a "All" and a "None" category. Thanks in advance for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to remove Drop Page Fields Here from Pivot Table | Excel Discussion (Misc queries) | |||
Pivot table and filter | New Users to Excel | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
filter on color-filled fields | Excel Worksheet Functions | |||
Is there an autofill for all row fields in a pivot table? | Excel Worksheet Functions |