1 Reply Latest reply on Jan 23, 2014 9:36 AM by Matt Lutton

    How to calculate YTD based on the file name?

    Chhatrapal Singh

      Hi,"

         I want to calculate YTD based on filename. I have excel sheet that have title "August 2013 Report". I want to use August 2013 for YTD calculation, though there is no column or row related to date. Sheet have dimension "Product" and two measures Sales and Target. Is there is any way to calculate YTD based on file name?