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

    Set analysis: Ignore or include selected dimension


      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!





      Message was edited by: mayank.rishu