14 Replies Latest reply: Dec 4, 2017 9:22 AM by nacera abbas RSS

    Cumulative Dimension

    nacera abbas

      Hello,

      I'm facing an issue about rangesum function in a Pivot table,

      I calculate a cumulative amount like this

      The expression:

      if((Dimensionality())=1,

      rangesum( sum(  aggr(   rangesum(   above(  Sum( {$<expr>} Amount)  ,0,rowno(TOTAL)  )  )  , Dimension 1  )  )

      , sum (Amount)

      I have 2 dimensions:

      Dimension1 diplayed in rows and Dimension2 displayed in Columns.

      This is how we want to display the pivot table:

      Dimension1Dimension3Dimension4Dimension2Z1Z2Total
      AA1102030
      AA2A21134
      AA2A22123
      AA2A23246
      AA2A24156
      AA2Total41418
      ATotal143448
      BB1235
      BTotal163753
      C173855
      D183957
      E194059
      FF1123
      GTotal204262
      Total204262

       

      And for the moment I have this:

       

         

      Dimension1Dimension3Dimension4Dimension2Z1Z2Total
      AA1102030
      AA2A21134
      AA2A22123
      AA2A23246
      AA2A24156
      AA2Total41418
      ATotal34034
      BB1235
      BTotal53053
      C55055
      D57057
      E59059
      FF1303
      GTotal62062
      Total62062

       

      Does anyone has any idea on how I could fix this issue?

      Many thanks,

      Nacera

       

      Ce message a été modifié par : nacera abbas