set analysis

[vidhyancs]

hi all,

need a small favor as i know that the below expression is to ignore the selections from Year, Quarter and Month and accept all other filters.

sum({$<Year=, Quarter, Month>} SalesAmount)

but what i need is i just need to accept the selections from Year,Quarter and Month and ignore all other filters.

Thanks in advance.

[Lech_Miszkiewicz · Accepted solution]

Maybe:
Sum({1<Year=P(Year),Quarter=P(Quarter),Month=P(Month)> SalesAmount)

[Lech_Miszkiewicz]

The onother thing is to consider if other selections can Include/Eclude data from your Year,Quarter and month fields