9 Replies Latest reply: Dec 16, 2015 1:35 PM by jim sullivan RSS

    Set analysis: Ignore or include selected dimension

      Hi,

      I am not able to find out how to ignore and include some of the dimensions using set analysis. For ex:

      Emp    Team   Sales

      e1        T1        1000

      e3        T2         500

      e2        T1         1500

       

      Now selecting e1 should give sum of corresponding team i,e 1000 + 1500 = 2500.

       

      I am using this expression in Text object:

      sum({$< Team = {$(#vTeam)}>}Sales) but result is 0.

       

      What is the error here?

      Also, what are other ways to achieve this?

       

      Thanks for your time!

       

      regards,

      Mayank

       

      Message was edited by: mayank.rishu