OBIEE 12c - How to do Row Totals in Pivot? — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBIEE 12c - How to do Row Totals in Pivot?

Received Response
31
Views
1
Comments
User_2V6CO
User_2V6CO Rank 1 - Community Starter
edited Aug 13, 2024 7:20PM in Oracle Analytics Cloud and Server

Hi,

Is there any possible way to display row level total at the end in pivot view?

for ex:

  7 Days            14Days          30days            Row Total

A                 5                  6               4                 15

B                 1                  2               3                    6

C                 0                  7               5                  12


I have 3 measure columns created in measure section on which days logic created and Total should show the sum of those rows.Plz sugguest.

Thank You.

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi  User_2V6CO ,

    Welcome to the Oracle Analytics Online Forum!

    To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

    Did you get the solution for this test case ? From UI we can able to get the column totals,Running Totals but for calculating the Row total you need to create separate column to add the same. its an Manual process only.

    Other comments are welcome.

    Regards,

    Arjun