Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Total of column

Hi,
I have column (eg:Sales), which is not aggregated in the rpd and should not be aggregated. It is just shown across a dimension column. But i have requirement where i have to do a total of the column across a static text. (like sales : 5000). when i am using sum over it for aggregation i am getting junk values. is there any way i can get the column total.
Thanks,
Kalpana
Answers
-
In the rpd go with 2 columns 1 for Sales which goes to dimension and other one is for sum(sales) which is for Facts in Presentation
in the report use accordingly
0 -
Umm do you want the total sales in a row of your table? or a column or your table? dont understand well your requirement.
1. However, if you want a calculation in a row:
-Please edit your view and in the View you could and set up you "Aggregation Rule"
2. However, if you want a calculation TOTAL in a Colum:
Create a column in your criteria section, and apply this formula: "sum( YouMeasure by "Sales")
Hope this help.
Kind Regards,
0