7 Replies Latest reply on Sep 23, 2019 9:30 AM by Sirisha T

    YTD total for every month.

    Sirisha T

      Hi, I have attached a sample workbook with sample data.

       

      I am showing "PMshow" amount for every month. This is a calculated field.  I need to also display YTD PmShow.

      For example, Jan 2019 should show Jan PMShow amount

                        For Feb 2019 it should display Jan PMshow + Feb PMshow amount

                           and similarly for rest of months.

       

      Even if I have last year data, it should show YTD for 2018 year. Right now I dont have 2018 data. But I am saying because the year should be dynamic.

       

      Please see attached workbook and appreciate your help.