I'm creating a pivot table that will have Item Categories and Items along the side, and Warehouse Locations across the top. I want to show a sum of sales in the table. The Item Categories and Items along the side should respond to filter selections, but the Warehouse Locations across the top should stay static -- i.e. always show all locations, even if the user has one or more selected.
I've tried a number of things with the set identifier, but don't see a way to call out a specific field. I'd rather not use a bookmark. I feel like I'm missing something. Can someone help? Thanks.
