Forum Discussion
Pivot Table - Hiding Rows Based on Column Value
A dirty solution would be to select the cell immediately to the rightmost header of the Pivot Table (PT), and then put a filter on that cell. This will insert filter buttons on each of the column headers inside the PT. Then you can filter out any value, e.g. blanks, zero's, amounts below, above or within boundaries. Whatever. The attached worksheet has a simplified example where the filter was put on L13. Just coloured it as an indicator. Now you can press the filter for product E and e.g. uncheck (Blanks). Hope this works for you.
Hello Riny_van_Eekelen , I was trying to figure this out for an hour and your solution worked perfectly! Unfortunately it doesn't apply to the associated pivot chart, do you know if its possible or not? Thanks in advance!
Paul_Hiroshi Can't really tell. Never tried that. Better to open a new conversation with your specific problem and add some more specific information.
- Thanks for the quick reply ! I'll open a new thread, thanks a lot