Percentages in expanded pivot table

[#1]

I have a pivot table with a calculated dimension, and am trying to get percentages to the calculated dimension level.

Collapsed, the percentages are fine. Expanded, '-' populated cells show up. I've worked over aggr with this with no luck. Sample aggr:

(sum(total_claim_count) / (aggr(sum(claim_count), claim_name, claim_status))

The calculated dimension involves three 'if' statements and does not plug into the aggr.

This has used up my blood on the keyboard supply for the weekend.

Help vastly appreciated.

kencho

[sathishkumar_go]

Hi

I understand ur problem. Better attach ur here?

-Sathish

[#3 · Accepted solution]

The solution is:

(sum(total_claim_count) / (aggr(nodistinct sum(claim_count), claim_name, claim_status))

nodistinct is what does the trick!

[#4]

Thank You. Thank You. Thank You!

[pablolabbe]

Why, nodistinct does the trick ?