Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
sum({<Fruit=,ID=p(ID)>}Pieces)
Can you post an example?
See if this helps? PFA
something like this:
Sum( {<Fruit=,id=p( {<Fruit=Fruit>} id )>} Pieces)
Perfect, thanks.
hi
Also try this
Aggr(sum(if(id<>3,Pieces)),Fruit)
Regards
vishwaranjan
Hi Vishwaranjan,
Why id>3 ?
I'm not sure what does it mean ?
Cheers,
Kenneth
Hi,
In below expression " <> " means, NOT EQUAL TO.
Aggr(sum(if( id<>3 ,Pieces)),Fruit)
Thanks,
Pragya