I face a problem with my Pivot Table. I would like to hide automatically the rows where there is no data in the TOTAL column (the last one). Is it possible?
Thanks in advance for your help!
Thank you Mark!
I see now what would be the solution, but I won't be able to use it since my 1NF has 20 different categories (DLXQ,DLXK,...) and more than 5000 lines for the time being. If I understand you properly, I would have to use different lines for each category and would then have 100'000 rows (less the ones with no value).
Thank you anyway for taking the time!