1 2 Previous Next 24 Replies Latest reply on Sep 24, 2016 10:30 AM by Jonathan Drummey

    How to filter and choose a part of data?

    Irina Zholudeva

      Hello, please help me. I have a table of data like this:

          

      Number of orderProductProduct groupPriceQuantityRevenue
      1AppleFruits31,03,0
      1MeatMeat20,71,3
      1PearFruits51,78,3
      1PotatoVegetables124,048,0
      2Pine-appleFruits62,012,0
      2PearFruits144,765,3
      2AppleFruits72,316,3
      3JuiceDrinks82,721,3
      3AppleFruits103,333,3
      3PotatoVegetables113,740,3
      4MeatMeat31,03,0
      4FishMeat20,71,3
      5FishMeat51,78,3
      5PearFruits124,048,0
      5MeatMeat62,012,0
      5JuiceDrinks144,765,3
      5MilkDrinks72,316,3

       

      I want to include into my analysis only those orders, which have Product group Fruits and Drinks in them. I want to see all information of the orders in which there is at least on product from the group I need.

      I don't know how to do it.

        1 2 Previous Next