I am trying to create Net Gain metrics which produces the difference in values of a metric across two time periods.

For example,

I have a report that tracks number of subscribers on a weekly basis broken down by the subscriber type. I would like to track the Net Gain as well as the change/movement of subscribers since the previous week. Below is the sample report:

"Subscriber Type"                        "This Week"            "Net Gain Since Last Week"

Direct Subscribers                        184,321                  421

Reseller Subscribers                     25,321                   (12)

Commercial Subscribers                12,837                   32

Therefore, "Net Gain Since Last Week" would be the number of subscribers for each subscriber type in the current week minus the previous week numbers.

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