4 Replies Latest reply on Aug 20, 2013 6:36 AM by Jackie Klein

    Automatically show prior month on report after new month starts and do not show new month until month is over

    Jackie Klein

      Hi,

      I have a report that compares last year month to this year month (Jan 2012 vs. Jan 2013).  I do not want to show last year or this year month until this year month is over and new month has started.  Is there a way I can set it up do do this dynamically/automatically?  Sample workbook attached.  The data in my actual file starts with Jan 2012, however sample data contains more data.  Also, sample file shows 2011 vs. 2012 data whereas my actual file is 2012 vs. 2013.

       

      Thanks much!
      Jackie