OBIEE — Oracle Analytics

Oracle Business Intelligence Applications

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

OBIEE

Received Response
11
Views
1
Comments

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 4Header 5Header 6
asdf2090
asdf50100
Grand Total70190

Answers

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

    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.