I have a report where I need to compare record counts from week to week for a given day and while I can get the field to show me last week's date, I cannot find a calculation that will pull the correct value for last week in to the row.
I have tried a few lookups but they all end up with either blank data or doing the data backwards (showing 3/8 data as the 'last week' data on 3/1)
The screenshot is a mock up of what I need the report to look like and the values that should be there. I have also attached a quick workbooks with the data in hopes that helps.
see the attached
this is the join clause
it returns this
NOW a word of caution - the example is a very simple data set - in your real data if there are other dimensions involved you will need to include them as a separate join and if the data is incomplete at that level it will cause problems
Jim
