exception in expression

Mon, 03 Dec 2012 17:11:12 GMT

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

Re: exception in expression

MayilVahanan — Mon, 03 Dec 2012 17:15:56 GMT

Sum

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

Hope it helps