null values in pivot table — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

null values in pivot table

Received Response
21
Views
1
Comments
3193829
3193829 Rank 5 - Community Champion

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.

Screenshot.jpg

Regards,

K

Answers