8 Replies Latest reply: Feb 6, 2018 11:35 AM by Youssef Belloum RSS

    Aggr by two dimensions

    Alip Nath

      Hello Experts,

       

      Need help in sorting out this solution.

      Requirement is to create a Percentage KPI by both the dimensions grouped by Dim 1 & 2.

       

      KPI is for every combination of Dim B we need to find percentage against Dim 1

      i.e for Dim 1 row 1 = 10/(10+30+50)


      Furthermore there is a need to calculate percentile as well.

       

      Sample data below:

       

      Dim 1Dim 2Measure
      One A10
      One B30
      One C50
      TwoD90
      TwoE1000
      TwoF200
      ThreeG700
      ThreeH890
      ThreeI12
      ThreeJ123
      ThreeK450
      ThreeL800