Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The solution is:
(sum(total_claim_count) / (aggr(nodistinct sum(claim_count), claim_name, claim_status))
nodistinct is what does the trick!
Hi
I understand ur problem. Better attach ur here?
-Sathish
The solution is:
(sum(total_claim_count) / (aggr(nodistinct sum(claim_count), claim_name, claim_status))
nodistinct is what does the trick!
Thank You. Thank You. Thank You!
Why, nodistinct does the trick ?