How to get a running aggregate for the last 12 months

User_OBCXC

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

Wayne Van Sluys

In your Pivot duplicate the column you want to have Running Sum, then on duplicate Select Display as Running Sum

Mostafa Morsy-Oracle

@User_OBCXC

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

User_OBCXC

Thank yo very much for your input.

Best Regards.