1 Reply Latest reply: Dec 3, 2012 12:15 PM by mayilvahanan ramasamy RSS

    exception in expression

      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