1 Reply Latest reply: Mar 13, 2017 3:58 AM by PAUL YEO RSS

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

    PAUL YEO

      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