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

    How to get current selection of the alternate state?



      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] )