4 Replies Latest reply: Jan 22, 2016 3:03 AM by Rohan DSouza RSS

    YTD without date field and month as text

    Rohan DSouza

      Hi All,

       

      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?