11 Replies Latest reply on Jun 25, 2018 9:53 AM by Deepak Rai

    Row level calculation

    vikram bharadwaj

      Could you please suggest me how to perform calculation from two rows in the same dimensions.

      If we take a example of Super Store.

       

      i want to calculate Sales percentage of dimensions (Segment) sales amount.

                                 

      SegmentMeasure Values
      Home Office429,653.15
      Corporate706,146.37
      Consumer1,161,401.34
      My Requirment   (Calculation)
      Home   Office/Corporate60.84%
      Corporate/Consumer60.80%

                                 

      Thanks in advance!!