taigovinda
Well-known Member
- Joined
- Mar 28, 2007
- Messages
- 2,639
Hi,
I want to be able to very quickly set pivot tables to hide all the rows that are missing data in ANY of the 1 to several data fields.
I'm thinking the best way to do this is to use vba to traverse through all the rows of the pivot table, and hide (i.e., uncheck the "show" box) all of the rows that are missing data in any of the fields.
Can anyone help me out with how to do this?
Thanks!
Tai
p.s.
I want to use this on pivots that are based on many different combinations of dozens of columns and thousands of rows, so I really don't want to add additional columns into the data source and then use them as a dummy variables in the page fields of the pivots.
I want to be able to very quickly set pivot tables to hide all the rows that are missing data in ANY of the 1 to several data fields.
I'm thinking the best way to do this is to use vba to traverse through all the rows of the pivot table, and hide (i.e., uncheck the "show" box) all of the rows that are missing data in any of the fields.
Can anyone help me out with how to do this?
Thanks!
Tai
p.s.
I want to use this on pivots that are based on many different combinations of dozens of columns and thousands of rows, so I really don't want to add additional columns into the data source and then use them as a dummy variables in the page fields of the pivots.