please see the attached workbook
Using a text table, when the filter is selected for the item where sales is null
want to display - " No sales value available" and nothing else.The text table should not appear only the text should come up.
Do you want to see "No Sales value" on the row for Item D and Item F? Or do you want to see "No Sales Value" when no items at all are selected?
Actually, I answered both questions in the attached workbook:
Retrieving data ...