7 Replies Latest reply: Mar 5, 2014 7:20 AM by Pooja Sharma RSS

    Expression with Alternate State not working

      Hi,

       

      In my Straight table chart I am using the following formula in the expression:

      num(sum({$<Customer = p({[AltState1]}Customer)- p({[AltState2]} Customer)>}Sales),'$#,##0')

      where I am trying to find out list of Customers slected in Alternate State AltState1 and not there in alternate state 2 AltState2.

      and the Straight Table is in AltState1.

      Whenever selection is made in AltState2 the values are not reflected.

      Dimension used is: Customer

       

      Thanks in advance!!

       

      Regards,

      Pooja