1 2 Previous Next 15 Replies Latest reply on Jun 29, 2018 10:50 AM by Shinichiro Murakami

    Current Ytd vs Prior YTD

    Dan Maycock

      I'm trying to generate a tabular chart showing current YTD compared to prior YTD calculated automatically for the given month based on the dataset available.

       

      Attached is a screen shot of what I'm attempting to build, along with a workbook with sample data.

       

      I've seen many calculations online that reference YTD for the current month, but I want to generate a trend pattern based on the month in question vs specifying a month / year in a dropdown so could use help thinking through how to calculate.

        1 2 Previous Next