percentofTotal Calculation with Count Distinct

Hello All

I’m trying to insert a pivot column to display the percentage of total value for various rows.

The row values need to be count distinct, so I can’t use the values fields or the percentofTotal calculation to do this.

Are there any workarounds that can be recommended?

Thanks

Hi,

Try this calculation

Percentage of Total= countDistinct({caseid})/sumOver(countDistinct({caseid}), , PRE_AGG)

1 Like