How do I get zeros in place of nulls in a pivot table in 11g Answers?
867265Jun 7 2011 — edited Jun 7 2011I have a pivot table with a number of cells with null in them. I want to replace the nulls with zeros.
I have tried the following:
Using the IFNULL function. This replaces nulls with zeros in all cells that exist in the base data table but not in cells that only exist in the pivot table.
E.g
Year Fruit Number sold Number returned
2010 apple 2 1
2010 pear 3 null
2011 pear 1 1
IFNULL would replace the Number returned for pear in 2010 as a 0 but not cells for 2011 apples since there were no rows in the table/query results.
I also tried the custom data format on the column (a recommended solution for 10g) but it had no impact in 11g
Thanks