Pivot table percentage calculation help

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

In the below table

Dimension is Division

Measure is Count(distinct ID)

Please help me to calculate the percentage like expected output column.

I have tried like Count(distinct ID)/Count(Total distinct ID) but getting wrong percentage.

Please help me on this.

Thanks in advance

[agigliotti]

what you tried seems to be right.

let's try adding Count( TOTAL DISTINCT ID ) as a new measure column to see what you get.

[agigliotti · Accepted solution]

do you have Division value as null ?

if Yes you can use this expression:

Count( DISTINCT ID ) / Count( {< Division = {"*"} >} TOTAL DISTINCT ID )