I've got a pivot table showing Sales Client, Sales Client Country and Sales client type. The Sales Client is a calculated dimension, so that it is only showing the top 100 clients. The reason I have it as a pivot is so that I can collapse everything down to only show the Client, such that each client has just one row, and the chart is able to show the volume for each client, but with the ability to drill down to country or type level.
However, I cant seem to find a way to collapse country and type down, I just cant seem to get the square + / - box for Sales Client. Is this because it is a calculated dimension? Is there another way of limiting Sales clients to those with the top 100 volume?
I dont really understand whats going on here, is there a way to specify which dimensions get collapsed and which dont that I'm missing? My other calculated dimension collapses fine?
