Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table with ID and account as rows, Month (Oct, Nov, Dec) as columns and a total field.
I wish to show the percentage of column total for each month and obviously that'd change dynamically as each item is being filtered on.
count(Measure) / Count(TOTAL <ColumnDimension> Measure)
Or
count(Measure) / Count(TOTAL <RowDimension> Measure)
Thank you @vinieme12 it worked perfectly. However, is there a way to keep the values fixed? Currently, the % values change based on whatever we filter. I'm wanting that even when I filter for a specific account type, it shows me as a percentage of the entire month, rather than as a percentage of the selection.