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!

       

      H