Is there a more elegant way to display "No Data"??

[#1]

I've been working with QV for a few months now and whenever there's no data available (see attached image) that happens.

The dynamic way a pivot table resizes based on the amount of data it has (again, see attached image, even if you have laid it out perfectly, it'll shrink) makes the title of the pivot table unreadable. Is there a setting somewhere I can set "don't $#%^^&*& SHRINK when there's no data!!?!" ??

Thanks

[#2]

Also if there's a nicer way to show "Sorry. No Data Available" *while* keeping the original size of the pivot table, it'll be awesome

[whiteline · Accepted solution]

Use Calculation condition (General Tab).

And edit the error message for 'Calculation condition unfufilled' (Button Error messages also on general tab).

[#4]

What would I put in the Calculated Condition to check if there's any data returned?

[whiteline]

Yes.

You have to write a boolean expression (that returns true or false)

For example:

=not isnull(SomeExpression)

=(SomeExpression) > 0

and so on.

[#6]

Is there any way to left align the error message?

[whiteline]

Hmm.

You can use your expression as a Chart Show condition so that the chart disappears.

And also you can create a text box with the format that you like and use a reverse Show condition for it.