7 Replies Latest reply on Feb 24, 2017 2:24 PM by Maria Trumble

    YTD Calculations

    Maria Trumble



      I am trying to create a ytd calculations based on some data.


      However my month dimension is not date formatted, but is string as it is just Jan, Feb, mar etc


      I currently have two sheets


      The first sheet is month of income statement, works a treat


      Second sheet is ytd income statement


      I have attached a screen shot of my income statement, any help you are able to give would be much appreciated


      It would be great if the ytd sheet is driven by the month of filter on my first sheet




      Income Statement Month of = Feb


      Income Statement YTD = Sum of Jan and Feb