Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to caculate the sales ignoring any selections except field 'Area'. Pls help me, thanks in advance.
zhou
Take a look @ this link Ignore all selections except some specific fields using Set Analysis
Take a look @ this link Ignore all selections except some specific fields using Set Analysis
Hello Zhou.
Try this :
Sum(<{Field1=, Field2=, Field3=}> Sales)
Let us assume that you want to ignoring the selections of Field1, Field2 and Field3.
Hello Zhou
you can by pass those fields which you don't want to affect the selection.
you can write set as follows :
sum({<area={'Area name'}, year={'year'}, field1=, field2=>}sales)
regards
harshal
There are up to 10 fields i should ignore...
I have tried this method and worked. But i think there is another simlier way. Thanks.
=sum(total Sales<Area>)
=Sum(TOTAL <Area> Sales)
you can try using
sum({<area = {"*"},Field2=,Field=>}Sales)
This will include include the area and ignore rest.
Thanks,
Angad
Thank you very much. A clever approach!