Trying to show grand total % in body of report

CArnold40

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.

Thomas Dodds

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]

CArnold40

That is perfect. Thank you!