Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
How to build an Analysis on OTBI to show cumulative totals over time?
Summary:
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):
Answers
-
-
My point is different.
My question is related to cumulative amounts over time. It means that a period have to show its own amount plus every previous period amounts.
The question you've mentioned lists periods with its specific amount.
Thanks
0 -
Hello,
You can try using RSUM calculattion to get the cumulative by month. Sample calculation as below. Also attching the report XML which I built.
RSUM("- Current Forecast"."Current EAC Cost" by "Task"."Project Number")
2 -
The option "by" you used on RSUM does not appear on function syntax (RSUM(expr)), but it worked fine.
Thanks so much for your help.
0
