AbrahamGluck
Board Regular
- Joined
- Apr 12, 2016
- Messages
- 129
- Office Version
- 365
- Platform
- Windows
How can I filer what records the pivot table includes in the aggregated field as the value field as a sum
I want when I click on the pivot table and it opens a new table to only see relevant data so I want to only include if the amount is not equal to 0 because I have a lot of those that's equal to 0 and when I click on the value I can see a lit of 100,000 records which are all 0 can this be avoided?
I want when I click on the pivot table and it opens a new table to only see relevant data so I want to only include if the amount is not equal to 0 because I have a lot of those that's equal to 0 and when I click on the value I can see a lit of 100,000 records which are all 0 can this be avoided?