Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI
Sum
({<Location={'3'},Supplier-={'IBM'}>}(Sales))
Hope it helps
HI
Sum
({<Location={'3'},Supplier-={'IBM'}>}(Sales))
Hope it helps