Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Trying to show grand total % in body of report
CArnold40
Rank 2 - Community Beginner
I want to build a report in OBIEE that is the same (in principle) to the one I am showing below:
| SalesAgent | Sales | InsideSales | %ofSales | Overall% |
|---|---|---|---|---|
| Agent1 | 10000 | 500 | 5% | 3.87% |
| Agent2 | 7500 | 125 | 1.67% | 3.87% |
| Agent3 | 15000 | 750 | 5% | 3.87% |
| Agent4 | 5000 | 75 | 1.5% | 3.87% |
| TOTAL | 37500 | 1450 | 3.87% | |
*Note - '%ofSales' = (InsideSales/Sales)*100
My problem is --
I do not know how to get that 3.87% (from the total line) to display on each line in the body of the report for my 'Overall%' column.
Does anyone know how I might do that?
Any help would be greatly appreciated.
0
Answers
-
drop a column on you report and change the formula to:
(SUM(InsideSales) / SUM(Sales))*100
taken from: OBIEE - Aggregation rules in Logical SQL with the GROUP BY and BY clause [Gerardnico]
0 -
That is perfect. Thank you!
0