Oracle Business Intelligence Applications

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

Grand Total Issue in Pivot Table

Received Response
21
Views
4
Comments

Hi,

The Grand Total column here is manually created by writing the formula (The 1 Total + The 1 CPN Total). I am using Pivot table for this report. Hence, arranged Layout as shown below and opted for aggregation as TOTALS AFTER.

My query is why the SUM for Grand Total column is not being populated? Please advise.

pastedImage_0.png

pastedImage_0.png

pastedImage_1.png

Thanks

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 6 - Analytics Lead

    Can you please set aggregation rule as 'SUM' for Grand Total formula column and try ?

    pastedImage_0.png

  • Rank 3 - Community Apprentice

    Hi ArijitC,

    I have the same problem.

    I am using aggregation rule as 'SUM' for Grand total, but iam not getting the sum as i expected.I am using Pivote table and Grand Total column at row level.

    As you suggested aggregation rule as 'SUM' it will work for normal table, not for pivote table.

    pastedImage_0.png

    pastedImage_1.png

    Thanks

  • Rank 6 - Analytics Lead

    Yes, that is correct. I overlooked that it is a pivot table, sorry. In pivot table, if you don't have the measure in Measure bucket then it is treated as attribute. If OBI thinks that it can do a group by then you will see pastedImage_0.png symbol. But for measure you will not see that.

    Thanks

    Arijit

  • Rank 4 - Community Specialist

    Hi Guys,

    Thanks for sharing your inputs. I have had raised an SR and ended up listening that it is not possible. As we are trying to place a measure column in rows which will not give desired result .

    Thanks

Welcome!

It looks like you're new here. Sign in or register to get started.