Can a Pivot Table display a second Grand Total row (one for total # and another for %)?

Hi All, wondering if it is possible to show to a second grand total row to show not only total numbers, but also a percentage breakout.

This is in an effort to show terminated employees as to why they left the company, and what level performers they were so we can look at why top talent is leaving. We want to show not only total numbers, but also how the performance ratings were broken out.

I have a sample attached just in case needed, thank you in advance for any suggestions. With this pivot table is a macro that allows users to break out by category such as gender or race, and the bigger reason for researching possibilities on adding the second total row to the pivot table so it can update dynamically.

Thank you for any suggestions!

Sheryl

Thanks so much for the quick response. The percentages are exactly what I need so thank you for that, however because this table is on a dashboard, I do not have room for the additional columns, and am wondering if it is possible to add an extra row to show those percentages under the totals.

Is that possible?

Thanks.

Thanks again. Unfortunately, I need the numbers to show in the table, such as in the first table, and hoping to add a second Total row to show the percentages. A separate table will not fit on the dashboard. I think what I need may not be possible as I was just looking to add a row under the Grand Total (#s) row to show the percentages, such as the 3.4% for the 1st quarter, etc.

Any additional suggestions, I'm all ears. Thank you again.

Sheryl

My suggestion in the file
Best regards

Thank you, I think this will do the trick, good alternative. Thank you all for your help.