Pivot table display both % of Row total and No Calculation - SOLVED

Hi All,

I have a simple problem and not sure if there is a solution out there. I have a spreadsheet with bunch of Pivot tables/charts. I would like to display the pivot table data as both % of Row total and No Calculation.

When I right click on the Pivot table data and navigate to Value Field Settings, I can click on the "Show Values As" tab and select "% of Row total" or keep it as "No Calculations" and displays the raw numbers.

What I really need is to display both???

I am hoping there is a way to do it and appreciate all the help.

Regards,

You can add a field to the values section of the pivot table more than once - then summarise one field by % of Row, and the other by No Calculation.