Calculate Percentage in pivot Table

Keitaru — Thu, 23 Dec 2021 18:19:25 GMT

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

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*+])

topic Calculate Percentage in pivot Table in App Development