Trying to show grand total % in body of report

Question

I want to build a report in OBIEE that is the same (in principle) to the one I am showing below:

SalesAgentSalesInsideSales%ofSalesOverall%Agent1100005005%3.87%Agent275001251.67%3.87%Agent3150007505%3.87%Agent45000751.5%3.87%TOTAL3750014503.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.

CArnold40 · Answer

That is perfect. Thank you!

Thomas Dodds · Answer

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]