1 Reply Latest reply: Jan 9, 2018 6:43 AM by Marcus Sommer RSS

    pivot table with rangesum

    Andrea Gigliotti

      Hello,

      Does is possible to have an expression total (for column) using the below expression:

       

      rangesum( before( sum(sales), 0, RowNo() ) )

       

      as accumulate measure over months ?

       

      for example how to have total for jan, feb etc... ? now I'm getting 0.

       

      many thanks in advance.

       

      best regards

      Andrea