1 Reply Latest reply on Oct 18, 2018 11:00 AM by Matt Lutton

    Current date_Current MTD and with YoY% comparison in one table (*by dynamic user choosen date)

    Nandha Kumar Murugesan


      I have a scenario like below

      i want to display a date filter (*end_date--- choosen current date) to choose by user

      and to display a month to date current sales
      and the comparison on month to date previous year month to date sales

      Finally all 6 to be displayed in one table format.



      I have tried a range of comparison from start to end date range filter

      as it get applied to page it didn't make sense as the filter gets removed the previous ranges