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

    Help for calculation

    KENNETH ANDERSEN

      Udklip.JPG

       

      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?