pivot table column percentages

user12621

Is there anyway to display percentages in pivot tables, in terms of cell count vs total column count?

 

I have attached an example.
In each cell with 'XX.XX%' I want to display the percentage of the count for that cell divided by the grand total for that month.
E.G. the percentage cell for "2020-Apr, In SLA" should show 93.25% (using cell count 22715 divided by column count 24358).

 

Thanks

jaeW_at_Onyx

https://www.youtube.com/watch?v=ZPf41Fjn1H8

 

I did a tutorial video on this very topic!

Check it out.

You may need to contact your CSM to get 'window functions enabled in beast modes' before you can proceed.

 

here's another permutation of Window Functions in case you're interested.  https://www.youtube.com/watch?v=cnc6gMKZ9R8

 

Hope this helps!

jaeW_at_Onyx

https://www.youtube.com/watch?v=ZPf41Fjn1H8

 

I did a tutorial video on this very topic!

Check it out.

You may need to contact your CSM to get 'window functions enabled in beast modes' before you can proceed.

 

here's another permutation of Window Functions in case you're interested.  https://www.youtube.com/watch?v=cnc6gMKZ9R8

 

Hope this helps!