How to display 2 years of data when one is selected in list box

[gerrycastellino]

How do I show my year sales as bar chart as in the below example on left in a bar chart when I have only 1 year selected.

qvw file attached.

[arulsettu · Accepted solution]

check this

[nagarjuna_kotha]

Hi use this expression:

sum( {<Year={'2014','2015'}>}Sales)

Regards,

Nagarjuna

[jvishnuram]

Hi Gerry,

Use the following expression

Sum({$<Year={">=$(Max(Year)-2)<=$(Max(Year))"}>}Sales)

[gerrycastellino]

perfect !

[ecolomer]

Two solutions