I created a PivotTable to present the budget for the year using 2 Categories (A, B) and also create a Calculated Item (= Spending / Budget) showing the percentage of the budget used.
In the first Pivot Table of the image the percentage calculation does all right, but when another subcategory is added makes the sum of all percentages instead of just showing the calculation of single row “A” that would have to be 79% (second PivotTable of the image)
There is any way that when the pivot table is collapsed not show the Summarize Values of all Percentages Values within his Category, and when the PivotTable expand only do the Calculated Item but row level, I whant to see like in 3rd PivotTable of the image.
In the first Pivot Table of the image the percentage calculation does all right, but when another subcategory is added makes the sum of all percentages instead of just showing the calculation of single row “A” that would have to be 79% (second PivotTable of the image)
There is any way that when the pivot table is collapsed not show the Summarize Values of all Percentages Values within his Category, and when the PivotTable expand only do the Calculated Item but row level, I whant to see like in 3rd PivotTable of the image.
