set analysis with different alternate states

[Anonymous]

Hi all,

I have a chart which should have an exclusive filter for it. i.e. this filter when selected should affect only this chart.

But this chart should be responsive to other filters as well.

for e.g in one sheet I have chart A and Chart B

Filters are filter 1, filter2, filter 3.

Filter 3 should be only for chart B. when any selection is made in filter 3 it should be reflected only in chart B.

But when any selections made in filter 1 or 2 should also reflect in chart B.

Kindly let me know if this can be achieved by alternate states

Thanks,

Anupama Jagan

[swuehl · Accepted solution]

Yes, it should be possible to achieve this using alternate states:

1) Create an alternate state AS

2) Set the listbox for filter 3 to state AS

3) Leave the chart B inherited from default state

4) In the chart aggregations, use set analysis to bring in the selection from the alternate state list box:

=Sum({$*AS} Value)

or

=Sum({$<[Filter 3] = AS::[Filter 3]>} Value)

[Anonymous]

Thanks a lot Stefan!