This content has been marked as final. Show 1 reply
In my sample workbook, 18 unique cities don't have any sales in the sub-categories of furnishings, storage, machines, and supplies. I would like the detail table display the 18 cities (for the unselected sub-categories only) and all the corresponding sub-categories with sales, including the selected sub-categories and the unselected sub-categories. I used the chart as a filter, but the filter is not working because city is a missing field on the chart.
Thank you in advance!