2 Replies Latest reply on Aug 29, 2018 10:38 PM by Tushar More

    MTD YTD with filter on date

    Josephine de Guzman

      Hi,

       

      I've been looking around the community but couldn't find the exact scenario.

       

      I need to have a table like below with the MTD, YTD, and Previous Year's result but with a filter. If the user select December 2017, it would show the result for the month and for the YTD (Jan-Dec 2017), and same as for the previous year.

       

      Hope you can help. Thank you!