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

    Percentages in expanded pivot table

    kencho

      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