5 Replies Latest reply on May 3, 2016 5:42 AM by Kyle Boyce

    show max date within window

    Hannah Moore

      I would think this would be a simple thing to solve, although I haven't been able to figure it out.  Basically, my data source has multiple entries for an item within a given year.  I want my report to only show the records for the last date within a given year.  I've tried using top 1 date as a filter, but it only gives me the top 1 in aggregate (not the top 1 for each year as I would like.) 

       

      In the attached, I'd like to show September FY2011 and ONLY June FY2012 (i.e. hide January FY2012.)

       

      Help please!  I know I'm probably missing something simple...

      Thanks!