3 Replies Latest reply: Jan 29, 2013 2:13 PM by Henry Noh RSS

    How show in Dimension, ONLY CLIENTS for which exist revenues

      I have a straight table with:


      Dimension:          Expression              Expression

      CLIENTS             Total Revenues        Revenues only with Salesgroup A



      Currently because I have an expression for Total Revenues, I'm getting the full list of clients in the dimension.


      I'd like to list only CLIENTS which have revenues with Salesgroup A.


      Is there a way to do this with set analysis in the Dimension?


      Thanks in advance!