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