1 Reply Latest reply: Apr 25, 2017 10:43 PM by Anil Babu Samineni RSS

    conditional sum in pivot

    m m

      StudentName
      ScoreAge

      A

      5521
      A4319
      A5518
      B55

      27

      B43

      18

      B4417
      B3318
      B4325

       

       

      How can i create a pivot with subtotal of score only if Age is less then 20. Sub total will ignore the score for Age higher then 20.