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

    YTD Calculations

    Maria Trumble

      HI

       

      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

       

      Example

       

      Income Statement Month of = Feb

       

      Income Statement YTD = Sum of Jan and Feb