This content has been marked as final. Show 8 replies
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?