Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Business Intelligence Applications

Categories

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

OBIEE

Received Response

11

Views

1

Comments

3672961

3672961 Rank 3 - Community Apprentice

Sep 5, 2019 12:46PM in Oracle Business Intelligence Applications

Hello All,

Please I want to know if it possible to sum up Grand Totals that is 70 and 190 in OBIEE Analysis as indicated below:

Thanks.

Header 4	Header 5	Header 6
asdf	20	90
asdf	50	100
Grand Total	70	190

0

Answers

[Deleted User] Rank 2 - Community Beginner

Sep 6, 2019 4:44AM

New column "All" with formula

AGGREGATE("Columns"."Header5" AT ) + AGGREGATE("Columns"."Header6" AT )

That's the most you can expect. And also: fuzzy, generic problem description = fuzzy, generic solution approahc.

0