Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like the attached app
Yes, It is possible by help of enable the condition from general tab. Will you able to provide Data or application?
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
Hi Sushil,
I tried this, did not help.
Adding a sample application. Here when i select UK, the table collapses. Instead want it to display "no data to display"
Try like the attached app
see this
Thanks it worked
Thanks it worked
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,