Calculate Percentage For Subtotals In. The trick lies in creating the measures. ISFILTERDProductsProduct This tests to see if the products column has any filter on the products column.
Select Analysis Percentages Of and then select a percentage option. I have 2 columns SubFamily and within it I have Brand names so I need to find the percentage of each Brand within that Sub family and the sub family should also show percentage of the grand total. These two calculations let you see an items percentage based on its parents subtotal amount.
The Model Amount is pretty straightforward because it can be calculated by using the ALLEXCEPT function which keeps just the filter on Model Name over the Product table.
I hope this resolves your issue if it does not please let me know what am I missing. In the next column over I would like to calculate the percentage of a value compared to the subtotal. Subtotal9D2D21 When you first enter this formula in cell D22 it gives you the total amount the same as when you enter the Sum formula. We have a source sheet for excel pivot which has a calculated percentage field eg age Variance.