How to get YTD , MTD values in a chart on selecting corrsponding YTD , MTD in a list box?
I need to display my SALES and BUDGET data in a chart. The requirement is to get YTD data, when YTD is selected, MTD when MTD is selected I have put these in a LIST BOX and displayed them as LED. I am trying to use
// This is put as respective flags in the master date table:
inyeartodate(DateString, today(),0,4 ) * -1 AS YTD,
InMonthToDate(DateString,today(),0)*-1 AS MTD
// Sales and Budget Expression used in the chart to display data:
// INLINE table for creating LED list box:
LOAD * Inline [
I am stuck at how to link my LED LIST box with this, so as to when I cllick on YTD or MTD on list box it, would show me the corresponding data?
I know that the FLAGS need to go into the expression somehow, but not able ot figure it out completely. Plase help!!