How to display a YTD, LY YTD and 5 years in the same chart?

[#1]

Hi,

This might be very easy but I could not figure it out.

Problem: I have 5 years data. I need a chart like attached pic where I should show the last five years data and alongwith the YTD and LY YTD. Only YTD and LY YTD values would change based on users selection of a month.

Appreciate any help!!

Thanks,

Archana

[#2]

Hi,

   PFA the application i tried. Perhaps, this might give you some insight.

Do let me know how it helped or need some more clarifications.

Regards,

-Karthik

[its_anandrjs]

Hi Karthik,

Do you share a excel file also which is a base file for ytd.qvw.

Regards,

Anand

[#4]

Hi Anand,

  right now i dont have access to it....however, you can put the not-derived columns in script into a table box, export to excel have the same from the application itself.

All the best....

Regards,

-Karthik