Trying to add percentages in a pivot table

ibtisamyyy

Hi,

Would anyone be able to help me with the following:

I'd like to have my pivot also show percentages of these two columns, I managed to get it to look like the bottom part however when I add a new column in the pivot it says the processing has not worked.

Not sure how to add in the percentage?

Thank you!

GrantSmith

What is your beast mode you're using to calculate the percentage? Are you able to use a Magic ETL to pivot your data, calculate the percentage and then display the resulting data using a regular table instead of a Pivot?