Set expression how can 1 exclude 2 condition ?

[paulyeo11]

HI All

Below expression work fine :-

Sum({<year={">=2015"},sub_seg={"02"}>} sales)

I want to modify the above expression with exclude seg=02 , it work fine :-

Sum({<year={">=2015"},sub_seg|={"02"}>} sales)

Now i encounter problem , when i try exclude one more seg=01 :-

Sum({<year={">=2015"},sub_seg|={"02"},sub_seg|={"01"}>} sales)

Can some one advise me where go wrong ?

Paul Yeo

[kaushiknsolanki · Accepted solution]

Try this.

Sum({<year={">=2015"},sub_seg-={"02","01"}>} sales)

Regards,

Kaushik Solanki

[paulyeo11]

Hi Kaushik

Thank you very much. it work

Paul