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

    Conditional Summation of Pivot Rows

    guy benhaim

      Hello,

      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.

      temp.PNG

       

       

       

      Best