This content has been marked as final. Show 4 replies
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.