Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 55 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How to get a running aggregate for the last 12 months
User_OBCXC
Rank 2 - Community Beginner
Hi everyone,
I have an analysis where I calculate the win and losses (in percentage) for every month.
The screenshots are the criteria and the results of my analysis.
Is it possible to somehow create another column (called "aggregate") to get the running aggregate of the last 12 months? If yes, how should I proceed?
Thank you in advance for your support.
Best Regards
Tagged:
1
Best Answer
-
In your Pivot duplicate the column you want to have Running Sum, then on duplicate Select Display as Running Sum
1
Answers
-
You may also check
https://docs.oracle.com/en/middleware/bi/analytics-server/datamodel-oas/model-time-series-data.html#GUID-B7C1DB63-74C7-46A4-B4C1-A647453DA92B
2 -
Thank yo very much for your input.
Best Regards.0





