I have a pivot table that gets its data from an SQL server SQL connection.
It's sales information, grouped by month and different items.
I have set up the pivot table to show me the percentage of sales for each different item
e.g January - 25% CDs, 50% books, 25% Tshirts
I did this by showing the summarised values as a '%of row total'
However, if I hide one of the items, it changes the row total, and hence the percentage.
Is it possible to retain the % calculation based on the row total, ignoring any hidden fields?
I thought that might be what the difference between '%of row total' and '%of parent row total' is, but it doesn't seem so.