Yes, I'm afraid I'm back.. I just can't get this to work out.. I've attached a screen print this time of my report along with a PDF of what the report looks like thus far.
In the GROUP FOOTER 3, under the YTD column (row LY for last year), I am trying to get a sum of the Months that are <= current month but in the previous fiscal year which run from 10/1 to 9/30..
So at this moment I'd only want to see a sum that would run from 10/1 through current for the previous year.
Then I would want this to continue automatically going forward without the user needing to put in any dates. I am just not advanced enough to pull this one off. I've tried everything I can think of.. Including a formula someone shared with me on an earlier post.