Forum Discussion
Pivot Table - Hiding Rows Based on Column Value
Hello! Seeking guidance on how I can hide rows in a pivot table if the value in a certain column is zero. Overview: I have a data dump from an accounting database with > 100k sales transactions....
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