Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can you hide the Grand and Sub total of a Measure column?

tryn2getitrightMay 17 2012 — edited Sep 20 2012
Hello Everyone,

I am using OBIEE 11g .6. I have a column that is a running total by an id number. I want the running total to show in the rows but summing the running total is pointless. When a change the aggregate level of the running total to none the running total column turns empty and has no values.

example

id amount running_balance
1 10 10
1 5 15
1 15 25 <---- total row
2 3 3
2 1 4
2 4 7 <---- total row

I would like to not show the 25 and 7 total value.

Thanks!
Reta
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 18 2012
Added on May 17 2012
#11g, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #report
2 comments
3,331 views