Trying to add percentages in a pivot table

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!


Comments

  • GrantSmith
    GrantSmith Indiana 🥷

    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?

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**