Linking 2 states

[#1]

Hi,

I have created the following:

- 3 states (Main, Sub1 and Sub2)

- 2 charts

- Input data (ProductStatus, Price and Region)

Let's say ChartA displaying ProductStatus ('Cancelled','Expired') and ChartB displaying ProductStatus ('Available').

In my chart expression i'm using "Sum({Sub1}[Price])" for ChartA and "Sum({Sub2}[Price])" for ChartB.

My question is how do i change the 2 charts' value if i change the region in Main state?

* Sorry for my bad explaination

[#2]

How do i link 2 states in the expression?

example something like "Sum({Main}{Sub1}[Price])"

[rwunderlich · Accepted solution]

Sum({Sub1<Region = $::Region>}[Price])

See the "What's new in QV 11" in your getting started page for a working example.

-Rob

http://robwunderlich.com

http://masterssummit.com

[#4]

thank you.