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!

Report Total Formatting

ChetanJun 10 2013 — edited Jun 14 2013

Hello,

My requirment is as below.

I have 3 columns Country,State,Sales and want to create a report where i want a blank row after every Country Total.

also want to give some color to that blank row.i tried with Union request but not getting report exactly like this.

eg.

Country State Sales
USA Florida50000
New Jersey5456465
New York868465
USA  Total6374930
IndiaDelhi85648
Maharashtra695445
India Total781093
Australia Queensland 595566
Tasmania785466
Australia  Total1381032
Grand Total 8537055

If someone did this before please help.

I am suing OBIEE 11.5

Any help will be appriciated.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2013
Added on Jun 10 2013
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #report
16 comments
990 views