Is there a way that I can create a formula that will look at same period last year using LastFullWeek or similar to gather information for that period ?
Example
Description Last Week Last Year same period ---------------------------------------------------------- Supplies 340.00 220.00
I would need more information to answer this question. Can you tell me do you have the data in the SQL query that supports this report or are you looking for the formula to do that?