We have a custom object which we call 'Subscription'. It has the following:
Start Date
End Date
We would like a report which can give us a breakdown of 'Active' subscriptions for the next, say, 6 months, broken down by month. E.g.:
January 2013
Subscription 1
Subscription 2
February 2013
Subscription 1
Subscription 2
Subscription 3
March 2013
Subscription 3
April 2013
— none
May 2013
— none
June 2013
Subscription 4
and so on. If we get this basic structure then we can summarize by Subscription price to see how much we get for next X months and so on. Being quite new to this I am at a loss as to how to create such a report though I am sure it is possible. Can anybody help?
Many thanks,
M
Best Answer
Are your subscriptions monthly? And do your Subscription records reflect this month-to-month renewal? You can get the report you want if this is true.
If each of your customer accounts has one Subscription record for every month of the subscription, you can create a report that's grouped by *Start Date" which would yield a report chart like the following.