Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Hiding Data on a PivotTable
- Thread starter Igwiz
- Start date
SkipVought
Programmer
Hi,
I know of no way to do what you want directly in a Pivot Table. You can't even use a filter in a PivotTable.
However, I have used AutoFilter outside a PivotTable on data referencing the PivotTable. You just need to be aware that you could filter a row containing ROW LABLES.
Hope this helps
Skip,
Skip@TheOfficeExperts.com
I know of no way to do what you want directly in a Pivot Table. You can't even use a filter in a PivotTable.
However, I have used AutoFilter outside a PivotTable on data referencing the PivotTable. You just need to be aware that you could filter a row containing ROW LABLES.
Hope this helps
Skip,
Skip@TheOfficeExperts.com
- Thread starter
- #3
Thanks Skip but not realy what I need. I fear you may have answered my question though in saying you can't filter a pivot. I need to base the exclusion on the sum of the data itmes to know whether two items have cancelled each other out (ie sum = 0).
- Status
Similar threads
- Locked
- Question