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 %