Alternate States - using Expressions

[#1]

Hi All,

I have a Line /Bar Chart - using the bars to show my current forecast and the line to show one from a set of  previous forecasts. To allow the user to select which previous to select I set up two list boxes for ForecastVersion. I then added the following expression to enable the first state (Forecast1).

  Sum({Forecast1 <Measure ={'Printer Sales'}>}Data)

I have a similar expression for Forecast2. My problem now is that I can't use any of my other Measures such as, Region, Year, Market etc..  Can anyone help me to understand how to set up my expression to allow selection of these other measures to affect my chart? I've tried setting these other measures to Inherited and Default but to no avail

Thanks

John

[tresesco]

Have a look here: Is possible to use alternate States with set analysis

[er_mohit · Accepted solution]

To reflect other fields on this

try this

Sum({Forecast1 <Measure ={'Printer Sales'},Region=$:: Region,Year=$:: Year,Market = $:: Market >}Data)

[#4]

Thanks for tha Mohit, I actuall had it right initially but forgot that I had renamed the Dimension- duh

[dirk_konings]

or this to have all selections included for an intersection

Sum({$*[Forecast1] <Measure ={'Printer Sales'} >}Data)

Dirk