Hi everyone,
I have a pivot table that sources its data from a table in another sheet. The sourcing table includes multiple lines, including blank ones for the user to populate when needed (the size of the table is fixed, hence the need for empty lines). The last column ("TOTAL") of the table is a formula that applies to all lines, even the empty ones.
When creating a pivot table from that source, I end up with a "Blank" category in my slicer. I see that if I remove the formulas of the last column for the empty lines (the "0" in red in the attached doc), it solves the issue. However, I need to keep this formula throughout the table because I need to have a "Total" column in my pivot table (and I dont want to need the user to add the formula on each new line he populates).
It's probably clearer when looking at the attached file but please let me know if I'm not clear
Thanks a lot
Bookmarks