This content has been marked as final. Show 2 replies
We need to measure “ongoing subscriptions” count which is sum of previous day's ongoing subscriptions and current date subscriptions.
For day#1 Ongoing subscription is same as Subscription count.
Screenshot#1 Cumulative sum for the whole date range
Screenshot#2 Cumulative sum for the selected date range. Desired value is in highlighted color below which is calculated separately and added to the screenshot
Screenshot#3: Cumulative sum for the entire date range for the selected filter
Screenshot#4: Cumulative sum of the selected date range and the filter. Desired result is highlighted and added in the below screenshot.
I would greatly appreciate if someone can help me with this problem?
FYI... I tried other approached like
Thanks and I appreciate any help.