4 Replies Latest reply: Nov 28, 2013 10:22 AM by Dirk Konings RSS

    Alternate States - using Expressions

    John Murray


      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