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?