4 Replies Latest reply on Aug 2, 2017 8:57 AM by Cynthia Derksen

    Table and Graphic displaying Last Year total - this year by month then YTD.

    Cynthia Derksen



      This is where I am stumped.    I don't know how to split a date?  Is it a formula or some kind of grouping that I need to do in a calculation or something?

      Anything would be helpful!  Right know, I have been piecing 2016 in one table to a 2017 Monthly table with a YTD total. 


      It is hope to have a graphic show the say way too.


      Sales2016 YEJan-17Feb-172017 YTD (Calculated Total)
      Total (Calculated Total)$6,000.00$250.00$650.00$900.00