2 Replies Latest reply: Apr 26, 2012 2:31 PM by d.b.magnus RSS

    How do you use multiple Alternate States in an Expression (Set Analysis?)

      I am new to the concept of Comparative Analysis.  I've created two alternate states for two list boxes.  These boxes each have a list of Dates for which I'm comparing sales (in a Bar chart).  Here is one of the formulas I'm using:

       

      Sum ( { [Group1] } Sales)

       

      My problem is this: when I select values in other List Boxes the values in the Bar chart do not change.  I thought perhaps I need to assign the other List boxes their own alternate states/groups, but then I can't figure out how to use these other alternatet states in the set analysis/expression.

       

      Does anyone have any ideas on how to use multiple list boxes/alternate states in an expression so that they will show the appropriate values in my Bar chart?

       

      Thanks!    Dan