Have a chart containing unselected values ?

[fredericvillemi]

Hello,

I have a crosstab list with several Dimensions : Region / Country / City  and a few KPIs : amount of Sales / nb Customers

The chart shows all the data and when I select a specific Region, it filters on this region. Great !

Now I would like to have a second chart which contains the opposite of that :

• Nothing when everything is available in the first chart
• all the non selected region or other dimensions when a region is selected and shown in the first chart

I tried something like {1-$} but it's not good, but I'm probably not too far.

And, bonus question, how could I merge that in a single chart ?

For exemple having one more first dimension called "Scope" with everything selected in "Current Scope" and all other data in "Others" scope

Thanks

[krishnacbe]

Try below Expression

Sum({<Region=E()>}Sales)

[fredericvillemi]

Hello,

that's really nice, not the same thing as {1-$}

And can I cumulate dimensions ?  Region=E(),Country=E() ? is there a priority ?

Thanks

[krishnacbe]

I hope no Priority is needed.

[krishnacbe]

I will set the excluded values based on the order you mentioned.