Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Keitaru
Creator
Creator

Calculate Percentage in pivot Table

I have a pivot table which i want the content value to be changed from a numeric value to a Percentage value:

image.png

 

Total: to show total % value

Miss TRO in % value across the months

Within TRO in % value across the months.

How do I achieve this?

if tried the following but it doesn't work

Count( {<[Status*]-={'Closed','Cancelled','Draft'}>} Distinct ID) /
Count( {<[Status*]-={'Closed','Cancelled','Draft'}>} Total  [ID*+])

0 Replies