I'm working sense and I have a problem with pivot tables.
My pivot table has 2 dimensions,...
How to keep the percentages when you select in these 2 dimensions?
Keep the percentages? Not sure I understand, would you be able to elaborate?
Can you attach a sample file and elaborate what you exactly want, so that it would be easier to understand and provide the solution.
It depends on how you calculate the %, and also on how you want it to behave on selections.Not enough info to help you yet.
Retrieving data ...