4 Replies Latest reply: Nov 26, 2014 2:31 AM by Ashif Tadvi RSS

    How to get current selection of the alternate state?

      Hi,

       

      I have 2 alternate states (Main and sub). How do i get the current field selection of the state in my expression?

      Basically i have 2 sheets and I do not want the field selected interfere with each other.

       

      Sum( { [Sub] <[Count A] = $::[Count A]>} [Budget Value] )

       

      I wan to achieve something like

       

      Sum( { [Sub] <[Count A] = [Main][Count A]?>} [Budget Value] )