4 Replies Latest reply on Nov 1, 2018 8:47 AM by venkatram

    MTD, YTD for this year and previous 2 years relative to today

    Richard Neff

      At one point I think I found the solution to this issue but I've been looking for several days and can't locate the solution again. I'm trying to calculate MTD and YTD for 2016, 2017, & 2018 relative to today for all years (don't ask me why, the powers that be require it and don't want to filter much. Attached is a workbook that gets be the YTD for previous years, but for some reason 2018 isn't showing up for MTD. Attached is the .twbx file, please let me know what additional info you need from my end to solve this.