"No data to display" message in pivot table

[poojask123]

Hi,

I have generally observed that charts display a message " no data to display" when there is no data to be displayed in the chart against a selection.

But when it is for a pivot table or straight table, it just displays zero or the table collapses based on the settings on Suppress Zero values.

I have a requirement to show "no data to display" message in a pivot table.

Is it possible ?

Please help.

Thanks

Pooja

[avinashelite]

It will show the same error but how the population can be -ve ??

[poojask123]

population is just an example i have taken here the actual field i am using is an amount field which can have 0, +ve,-ve and null values.

I want the chart to display whenever there is +ve n-ve data and show me the error message only when the value in field is either null or 0.

[avinashelite]

then change the condition like this

if(sum(population) =0 or sum(population) ='',0,1)

[poojask123]

Yea i wrote that n it seems to be working for now

Thanks