Oracle Transactional Business Intelligence

Products Banner

How to build an Analysis on OTBI to show cumulative totals over time?

Received Response


What is the function (or any way) of an Analysis report that shows cumulative totals over time, in the same way as it is displayed on attached file?

For example, an Analysis report using "Project Control - Forecasts Real Time" subject area and fields "Task"."Project Number", "Time"."Month" and "- Current Forecast"."Current EAC Cost".

What is the way to show the sum of "Current EAC Cost" from the first month up to each Month of a Project?

First month of a project shows only first month.

Second month of the same project shows first month plus second month.

And so on.

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):