When user select year = 2013 , how to write my expression can display 2017 YTD sales ?

[paulyeo11]

Hi All

I have 3 Table , may i know how to combine into 1 table ?

sheet 2013 = year 2013 compare to CY

sheet 2014 = year 2014 compare to CY

sheet 2015 = year 2015 compare to CY

Meaning instead of having 3 sheet , i only wan to have 1 sheet.

So when user

select year = 2013 , it will display 2013 compare with current year.

select year = 2014 , it will display 2014 compare with current year.

select year = 2015 , it will display 2015 compare with current year.

Hope some one can advise me.

As i don't know how to make the second display 2017 YTD sales when user select year =2013.

Paul

[paulyeo11]

My QVW