4 Replies Latest reply: Nov 7, 2018 8:51 AM by Markus Blaut RSS

    Sum formula Pivot table

    Markus Blaut

      Hello guys,

       

      can someone help me?

      • I have a pivot table with dimension "Product"
      • in the column I want to see the Quantity, but only from the highest selected year. (so if i select in a filter FY 2016,2017 and 2018) I only want to see the sum of the Quantity of 2018, and if I would select FY 2016 and 2017 I only want to see se sum of the Quantity of 2017, and so on...

       

      if i insert "sum(Quantity)" i get always the sum of all selected FYs. Any idea how that could work?

       

      Many thanks for any help!

       

      Best Markus

       

      Unbenannt.PNG