5 Replies Latest reply: Oct 12, 2018 5:52 AM by guy benhaim RSS

    Conditional Summation of Pivot Rows

    guy benhaim


      I have a pivot table with 3 dimensions, in which I would like to sum the "Dist" expression only for the rows that have "1" in their "load" expression in the row below. I did not manage to do it properly, such that if I collapse summation works.

              Aggr ... , TOTAL ..., Below() ....

      The lowest dimension is sorted, and "below" is determined by sorting.


      Please advise.