Set Analysis - filter on used fields

[twanqlik]

I've noticed that when i filter on the fields that i used in my set analysis, the outcome of my set analysis doesn't change. It only changes when i filter on the fields that aren't used in my set analysis.

Hence, Sum({<FIELD= {1}>} CONSUMER_ID)

Filter on Field, e.g. value 0.

The outcome doesn't change.

However, when i filter on the Country, the outcome changes.

I was wondering how can i write my set analysis in such a way that i also can filter on the fields that i used in my set analysis?

[sunny_talwar · Accepted solution]

Try this

Sum({<FIELD *= {1}>} CONSUMER_ID)

[twanqlik]

Thanks, that worked!

[sunny_talwar]

read more about it here
Implicit Set Operators