4 Replies Latest reply on Sep 25, 2018 9:22 PM by Mahfooj Khan

    How to create a set?

    Anky Lai

      Hello,

      i would like a dropdown filter called "Ice and Water included?" with 2 values "Yes" and "No".

      When i select "Yes", i want the total sales for IDs 1 to 10.

      When i select "No, i only want sales for IDs 1-4 and 7-10.

       

      Can someone please help? I have a feeling it has something to do with creating sets? I'm not too familiar...

       

      thank you!

       

         

      IDDescriptionSales
      1Apple10
      2Banana20
      3Cookies30
      4Melon40
      5Ice5
      6Water10
      7Grass25
      8Juice15
      9Tree10
      10Cat5