This content has been marked as final. Show 4 replies
I have a column with month names in it. E.g: JAN,FEB,MAR,APR,MAY,..... and a year column which has year names like Y-2014, Y-2015.....
I have added a year and months filter in the sheet. A line chart displays the trend according to months.
If I select a year, it shows all the months corresponding to that year in the chart. But once I select month, only that months data gets displayed in the chart.
I want to show a YTD in the chart i.e. all the months data should be displayed which are less than the selected month.
I do not have a date column here.
How do I do this?