I several pivot tables connected by a single slicer. Each of these tables have different metrics that are set to filter by the "bottom 10" based on the metric in the column (ie, dollar sales, unit sales, etc.). Sometimes when I choose a certain product, one of the pivot tables will not stay with the filter of "bottom 10" and will instead expand. I'm not sure if this has to do with some products that have 1 or 2 numerical values and then the rest of the metrics are "0". For example, I pick product "A" and I get 5 products with dollar sales. But when I pick product "B" I get rows. Its as if the filter that I thought I applied when everything was unfiltered/sliced doesn't roll down. Perhaps I'm not filtering correctly?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Value Filters in Pivot Table losing formatting when using Slicer?
- Thread starter treym
- Start date
Similar threads
- Question
