Exclude certain filters

[MuruKesavan]

Hi,

I'm trying to exclude certain data from this filter, i.e, all except Email. Can you please help me to edit expression to enable this function, below is the field and expression.

=[Profile Communication Type]

[AshutoshBhumkar]

Hi,

What is the expression you are writing in the straight table?

Like if you are adding Sum(Sales) and if you want to exclude 'EMAIL' Communication Type, then maybe you can write an expression like Sum({<[Communication Type] -= {"EMAIL"}>}Sales).

[MuruKesavan]

Hi,

No, I'm trying to set it to show only EMAIL as the only filter / rest to be excluded from this report.

[AshutoshBhumkar]

Hi,

Well, if you want to show only for EMAIL, you can restrict data in backend script.

Put in where condition like,

Load * where [Communication Type] = 'EMAIL';