Is it possible to create a "Last Year Same Week" metric.

For example,

I have a report that tracks number of subscribers on a weekly basis broken down by the subscriber type. Below is the sample report:

"Subscriber Type"                        "This Week"            "Last Year Same Week"

Direct Subscribers                        184,321                  174,631

Reseller Subscribers                     25,321                   24,728

Commercial Subscribers                12,837                   12,181

If "This Week" is 25 January 2013 with the number of subscribers at the end the week, the "Last Year Same Week" would be the number of subscribers at the end of "25 January 2012".

The above principle can be applied to Net Gain between months or years.

Is this possible to create without having to use custom SQL?

Thanks

Sunil