set analysis using alternate staes

[hopkinsc]

Hi all,

I am working on a client project and i need some help with getting something working..

I have a COMPARISON tab which has a set of charts on the left which are also duplicated on the right.

both sets of charts are to respond to all fields apart from 'Year'.

I have a year list box above each set of charts, both in different alternate states (StateA, StateB)

so the left hand side charts are to respond to all selections in the default state but not include the Year field (the one set at the default state) but instead would need to respond to the Year field in the StateA (and ignoring StateB)

and the right hand side charts would need to respond to all of the selections in the default state (apart from Year) but include the Year field that is in StateB but ignoring the Year field that is in StateA.

Does that make sense?

Can anyone help?

[simenkg · Accepted solution]

You can use the following syntax

sum({$<Year=[StateA]::Year>} Amount)

This will use all selections in the default state ($) but select Year from StateA

The reverse would be

sum({[StateA]<Year=$::Year>} Amount)

Regards
SKG