I have a main sheet for data, then I have a pivot table + pie chart attached to a slicer. How would I be able to select one (or more) criteria from the slicer and have the main data be filtered based on what I select in the slicer?