This would make another good one for the Ideas section!
I have had a similar issue and solved it....so you may be able to use this approach. It is dependant on you using a database - and being able to create a view.
- Create a view where your input table is Unioned to a set of dummy records - 1 for each company. The measures should be 0 so they don't affect your base data - but the Company ID/Name will be present.
- In your 2nd worksheet create a calculated field something like this:
if Total(sum([Retail Product Tonnes],0)) = 0
Then 'Sorry - but we don't not have data for this company'
3. Then put the calculated field as the first pill on the Columns Shelf. Fomat the text.
The message will appear across the top. Not quite as eloquent as what you have asked for - but at least it is claer for the user what is happening.