Cumulative Quarter
Hi Team,
I have data like
Sum of Sales for Q1 for 2016 = 309
Sum of Sales for Q2 for 2016 = 309
Sum of Sales for Q3 for 2016 = 309
Sum of Sales for Q4 for 2016 = 309
as shown in Pic 1.
I want the result shown in Pic 2.
May i know what function i need to use to get that result.
Kindly help me on this.
Thanks
Mohammed Jaffar Ali Shaik
-
Year to date could get you what you need. How to produce that was recently covered in a recent "Action on Insights" web series....
https://community.incorta.com/t/h7h81sl/icymi-action-on-insights-time-intelligence-with-incorta
-
Jaffar, Kurt,
This videos shows how you can do cumulative total by Year/Qtr:
- https://youtu.be/e-iiyaQnHv4
Thanks,
Anurag