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!

Display zeros in a pivot

user6787113Oct 1 2010 — edited Oct 1 2010

I have a one column pivot table that sums the values in a column. But, when my values add up to zero, it suppresses the column entirely. I want to be able to display the value of 0 in the pivot. I've tried using ifnull(colname,0) but that didn't work for me. Any hints?

thx

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 29 2010

Added on Oct 1 2010

#answers, #bi, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee, #pivot

3 comments

701 views