I need to create a report to view the growth of subscribers to specific programs. I created a matrix report with row groupings on Program and column Grouping on Subscription Date (Calendar Month).
I created a formula - SubscriptionCnt:SUM+ PREVGROUPVAL(SubscriptonCnt:SUM, Subscription_Date,1) but this considers only the previous value. It doesn't give me the total of all the previous subscriptions. I tried editing it to
SubscriptionCnt:SUM+ PREVGROUPVAL(SubscriptonCnt:SUM, Subscription_Date,1) + PREVGROUPVAL(SubscriptonCnt:SUM, Subscription_Date,2) ... and so on. This neither works. In this case it doesn't display the values for first two columns and displays for the third by counting all the previous.
Can someone help me correct the formula so I can display the trend of growth in an incremental way?