Pivot Table

[NavinReddy]

Hi All,

I have one pivot table

When i select any value in list box ,if value is null mean The table size should become small

how can i make it table should be same size ,if it value '0' also pivot should be same size

Please find the image

Thanks In Advance

Niru

[giakoum]

replace null with... something

[NavinReddy]

Hi,

I tried but im getting same

Thanks you

Regards,

Niru

[giakoum]

not sure what you are trying to achieve but deselect "Size to Data" in the layout and create a show condition : if there is no data, display some message.

[NavinReddy]

Thanks you its solve half of the problem

Where can i write the missage if there is no data mean

[giakoum]

Error messages in the general tab

[NavinReddy]

Yes but there are many option which option can i select

[giakoum]

Default or calculation condition unfulfilled in your case

[NavinReddy]

How can i write i tried but its not showing message

[giakoum]

It is a normal expression box. If you have a sample app I can help.