Select which level to show values on pivot table

Question & Answer
,
1

Hi,
I have a pivot table with categories and subcategories in rows and month in columns.
One of the values I am showing is %subcategoryA
So this value makes sense at a category level and total level but at the subcategory level it is meaningless… Is there a feature to select which level I want to display this value for on my pivot table?

eg. category 1 is 25% subcategory A
but within category1_subcategoryA will always be 100% and within category1_subcategoryB this will be 0%. So this should not clutter the table

2

Hi,

This is currently not possible. I can mark it as a feature request.

3