regarding charts

[venkatraw]

Here i am having two charts

only one chart should not change on selections when i select the dimensions

is there any solution

[#2]

Hi,

Use alternate states

which is available in document properrties---> alternate states

create a state der and place it in any chart which u dnt want to select

[venkatraw]

Hi i thought the same way but is there any answer rather then alternate stats

this is an interview question

he asked i replied the same

[jpenuliar · Accepted solution]

You can detach the Chart

[venkatraw]

Ya i said the same using attach and detach we can he says

he is not convenience'd still searching for it

[jpenuliar]

You can also use Set Analysis to Sum the Sales disregarding the current selection:

=SUM({1}Sales)

[jpenuliar]

  Returns the sales for region US disregarding/overriding the current selection in field "Region".

sum({1<Region = {'Eastern'}>} Sales)