Before a developer can use alternate states, at least one other state has to be created in the document. Under “Settings> Document Properties” there is a button for “Alternate States” on the “General” tab. For the example I will use later, I will create two states, “State1” and “State2”.
In standard alternate state logic, entire items can be set to react on another state. In the image captured below I have left the first list box and chart in the inherited state (the state that all objects will be assigned unless otherwise altered). After cloning both the list box and the chart, I have changed the cloned items’ state to react only to the State1 objects. Now, when a user selects items in the list box tied to State1 only the chart in State1 will filter on those values.
a friendly suggestion - when you marked a question answered and have a new issue, best way to get faster responses is to open a new thread.
alternate states is a simple way to do this as well...advantage is that you can compare not only with last year's but you can compare with any selection. however, you actually have to select a date in each state to compare. so depending on the requirement, i would modify/use the simplest approach. the following set analysis method works for the previous year comparison only.
this should help with your new requirement. assumption is that your Jan-2014, etc. are dates.