To calculate percentage of row sub total in excel pivot

Occasional Visitor

I want to calculate % of row total (but only for the row sub total and not the complete row total) in excel pivot table.

 

I was able to only find the % of row total in excel. I have created an example on what my problem is. 

 

I want to see the % of sales in japan for 2022 alone and likewise for 2023 instead of doing a complete row total and showing it as %exampleexample

0 Replies