8 Replies Latest reply: Apr 27, 2015 2:22 AM by Pragya Agrawal RSS

    Help for calculation



      This is a very simple data snip. I like to show which fruits people eat when the eat eg. Lemon.


      I select 'Lemon' in my filter


      I won't take ID 3 into the calculation as he doesn't eat Lemon which leaves me with ID 1 and ID 2.


      I like to show that:

      1 pieces of apple

      3 pieces of banana

      5 pieces of orange


      has been eated.


      How do I created a 'measure' to deal with the problem?