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

User_2V6CO

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.

Mallikarjuna Kuppauru-Oracle

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