exception in expression

[#1]

Hi,

pls help.

I have a simple pivot table with two dimensions (year,month) and to expression i need to say:

load all sales for dimension named "location",where is "3" and without data of IBM as i supplier 

Sum

({<Location={'3'},Supplier<>{'IBM'}>}(Sales))

It doesnť work because of <>,but i don´t know why and i neet to know another way how do this exception in expression

Thx a lot

Jerry

[MayilVahanan · Accepted solution]

HI

Sum

({<Location={'3'},Supplier-={'IBM'}>}(Sales))

Hope it helps