4 Replies Latest reply: Nov 27, 2009 8:56 PM by Pablo Labbe RSS

    Percentages in expanded pivot table


      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.