How to avoid null in pivot table while using input boxes

[prasadreddy]

Hi All,

Can any one help me on avoiding the empty cells in the pivot chart,

please take look on following attached screenshot,

i have given iput values to filter the data based on "difference", it working properly, but i want to appear only list based on the

input boxes, here the remaining is showing withnull symbol  ' - ', so i dont want to show that,

thanks in advance

[er_mohit]

in presentation tab  at bottom side you 'll find null symbol with - and missing symbol with -

replace null symbol with 0

hope it helps

[abeyphilip]

Hi,

As I understand you don't want the rows with '-' in your Difference column.

I am not sure if the pivot properties will let you do that since you have values for other expression columns in that row.

Can you try creating a list box that will have "yes" or "no" based on the value for Difference.

The list box expression will be something like:

if((aggr({<condition for 201211>} 201211),Account)

-

aggr({<condition for 201304>} 201304),Account))

>0, 'Yes', 'No')

So selecting "yes" will ensure you have only rows with value in Difference column.

[#4]

Try adding an extra condition in all of your expressions to say that if the result of that expression is "outside" (or whatever the requirement is) of your min. and max. difference, then show null() or zero. And how the setting to suppress zero enabled in the properties of the table.