Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Custom Grand Total in Oracle Analytics

Received Response
31
Views
3
Comments
3577947
3577947 Rank 1 - Community Starter
in Oracle Business Intelligence Applications

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..!

pastedImage_1.png

Thanks

Ramesh

Tagged:

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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.

  • 3577947
    3577947 Rank 1 - Community Starter

    Sorry to call reports..

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

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    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.