Custom Grand Total in Oracle Analytics

Question

Hi There,

I have a requirement like we have to calculate custom grand total in report level.

Example:

I have 5 members ,spend and visit for corresponding members. At row level we are calculating spend/visit, but need to calculate [sum(spend per visit)/ no of members] at grand total level.

Please help me, can we do this type of calculation in reports or not. If yes please suggest how can we achieve this.

Thanks in advance..!

Thanks

Ramesh

Jerry Casey · Answer

I use a union query in that situation.  The second query in the union is the same as the first, with the granularity stripped away (e.g. replace "Member" with the word 'Total').  The Avg Spending column can contain the calculation you described.
Formatting can make the new Totals record look like a standard totals line.

3577947 · Answer

Sorry to call reports..

Yeah Christian, we are using Oracle Analytics built on subject area.

[Deleted User] · Answer

Are you talking about OBI "analyses" built on Subject Areas?

Or about BI Publisher "reports" built on data sets?

Don't use "reports"just for anything because "people call it that". The term has a very specific meaning in the Oracle analytics world.