2 Replies Latest reply on Aug 28, 2018 2:09 AM by Tushar More

    Display Last Year and Current year in text table

    Amit Misra

      Hello,

       

      I have a table that has all the data corresponding to the current year, except for one measure-value column, on which I need to show the previous year's data,  The year is actually a single-value user-filter on the table. On this table, I need to show a measure value corresponding to the previous year when compared to the year selected in this user-filter.

       

      Example:

       

      If the year 2018 is selected, I need to be able to display the year 2017's  data in this measure-value column, alongside the rest of 2018's data.  If the year 2017 is selected, I need to be able to display the measure value corresponding to 2016 etc.

       

      My custom SQL data source data contains all year's data.

       

      How can I achieve the above?

       

      Please help.

       

      Thanks!