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

      Hello,

       

      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)
      Furniture$2,000.00$150.00$250.00$400.00
      Appliances$4,000.00$100.00$400.00$500.00
      Total (Calculated Total)$6,000.00$250.00$650.00$900.00