"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

[Anil_Babu_Samineni]

Yes, It is possible by  help of enable the condition from general tab. Will you able to provide Data or application?

[sushil353]

Hi,

go to General Tab of your chart property>Error Messages> Click on All expressions disable and there you can put your message to display.

HTH

sushil

[poojask123]

Hi Sushil,

I tried this, did not help.

[poojask123]

Adding a sample application. Here when i select UK, the table collapses. Instead want it to display "no data to display"

[avinashelite · Accepted solution]

Try like the attached app

[Kushal_Chawda]

see this

[poojask123]

Thanks it worked

[poojask123]

Thanks it worked

[poojask123]

Hi,

wat will be my calculation condition if i have negative numbers also as my value for sum(Population) ?

currently the condition is sum(population) >0,