null values in pivot table

3193829

Hi,

I have a report to display top 10 and other sales. I am using rank on sales and displaying top 10 and others.

the problem is my sales column has null values and the rank is not working for them. When i am selecting a dimension value for which sales has null, instead of top 10 it is displaying all the null values.

i am using ifnull in the column formula of sales(ifnull(sales,0)) but it is not reflcting here. I am trying to do the same from the RPD now.

How do i restrict the sales to display only top 10 even if it has null values or zeros.

Regards,

K

cesar.advincula.o

Hello,

In the metric of your "data format" try to put this:

#,##0;-#,##0;0

Check this link for more information:

http://total-bi.com/2010/10/replace-nulls-in-obiee-pivot-table/

Kind Regards,