Hi. When I use the slicer and select a field all columns of a pivot change. I would like to use slicer in a pivot and filter only in 1 column and the other columns to stay the same. How can I do that?
Thank you
Hi. When I use the slicer and select a field all columns of a pivot change. I would like to use slicer in a pivot and filter only in 1 column and the other columns to stay the same. How can I do that?
Thank you
Hi,
A slicer filters one field only. If filtering that field affects other columns in your pivot table there really isn't anything you can do about that. It might help if you gave a specific example of what you are talking about- then someone could perhaps come up with an alternative solution.
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks