OK, this is starting to bug me. It sounds like it should be simpler than it is. Basically, I have a number of records with a date field. I have been given a request for a report to have the following layout ('period' should be considered as the last 7 days) :

Item Desc. | Current Period | Current YTD | Last Year Period | Last Year YTD
----------------------------------------------------------------------------------------

Where each row gives the description and counts for each column according to the label.

I can't even get the Current Period to show properly. I tried creating a field with the formula :
{@date}=last7days
That gives me a count, but seperates it into two columns, true and false. I don't even know where to begin with the 'Last Year Period'. Can anyone help?

Thank you. This is exactly what I needed.