5 Replies Latest reply: Nov 12, 2015 9:51 AM by Sunny Talwar RSS

    How to get sum of the quantity sold only when satisfying two conditions

      Hi there,

       

      I would like to put the number in KPI only calculating hardware sold in 2015.

      Fields required (Values) to obtain the answers are Quantity sold, year (2015, 2014), and Product category (Hardware and consumables).

       

      Your thoughts are highly appreciated.

       

      Many thanks.