5 Replies Latest reply: Oct 17, 2012 5:45 AM by Stefan Wühl RSS

    Set Analysis Exclude

    Joe Kirwan

      I have 2 dimensions, ITEMCODE (which is a Product Code) and NAME ( a customer name), and a measure TR.VALUE.


      I have a simple table with dimension NAME and expression Sum(TR.VALUE).


      I want a table to show which customers have NOT bought a selected iproduct.


      I tried this:



      Sum ({$<NAME=E({1<ITEMCODE=>}NAME)>}TR.VALUE)


      but this gives me an empty table.


      Any ideas?