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!

Eliminate rows with Zero values in a column..

user8840662Dec 1 2012 — edited Dec 2 2012

Hi all,
I have a requirement, where in I have a pivot tabl.
I need to check a column, if that column has a Zero, I need to get rid of those rows in the report. BUT, I need to have the TOTALS unaffected because of this.

I tried filter on column in the report like this: COLUMN A IS NOT EQUALTO 0. I see the those rows are not shown in the report, But I see there is a change in TOTAL line.

I have a small example in the images.

This is my current report:
http://i.imgur.com/mvxSD.jpg

I want to eliminate those rows with zero quantity. But I need the TOTALS to be unaffected by this.
My desired report:
http://i.imgur.com/ob5fo.jpg

Unable to figure out how to implement this. Any ideas?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 30 2012

Added on Dec 1 2012

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

2 comments

747 views