4 Replies Latest reply on Jul 12, 2018 1:08 PM by Vidya Sagar Malla

    Show PIE Chart in Percent of Different calculated dimensional values

    Vidya Sagar Malla



      I am a new bee. I have a simple requirement. From the below data I want to create a PIE chart. PIE chart should show 3 slices of Top Category AUM (Top 5 Products = 25%, Next 10 Products = 25% and The Rest = 50%). I know I a need to use some LOD in AUM rank but no luck. A help would be much appreciated.


      Top Category AUM is a calculated column:

      IF [AUM Rank]<= [topn] then 'Top '+STR([topn])+' Products'
      ELSEIF [AUM Rank]> [topn] and [AUM Rank]<= [nextn]
      THEN 'Next '+STR([nextn])+' Products'
      else 'The Rest'

      AUM Rank is also a calculated column:

      RANK(SUM([Total AUM]))


      PIE Should look like this: