1 Reply Latest reply on Oct 3, 2018 2:04 PM by Yuriy Fal

    Missing field in Filter Action

    kate summer

      Hello all,

       

      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!

      Kate