Forum Discussion
Filter Pivot Data area to exclude results based on values of one Data area column
Hi, I am looking to see if there is a way to filter the data area in a Pivot table. The result I am looking for, is to filter out all rows, where in Period 7 (column H) there is no or nil value....
Hi MrStern
There may be a hack you can use.
Put your cursor in the cell above the pivot heading in column H then go to Data and click the Filter Icon. This should cause filters to appear above each Pivot Heading
Inspired by Bill Jelen's video here https://www.youtube.com/watch?v=xsiZTCG4FBc