Dec 13 2021 05:45 AM
hello
excuse me for my english, I'm french.
I'm using pivot table to make analyses based on data of 36 000 items.
My problem is the following : when I use a filter on the top of my pivot table, excel doesn't reduce the choices of items proposed in the table (lines or colums).
Someone has the solution ti reduce this choice?
Thank you so much for your help.
Gersende
Dec 13 2021 07:06 AM
SolutionHi @gerse21
instead of standard Pivot filters I propose that you use slicers:
For every field that you need to filter, you can insert a slicer. They are much more user friendly and if you have filtered one field with a slicer, the slicers for the other fields just show the relevant options.
Dec 21 2021 02:28 AM
Thank you so much !
it's exactly what I needed !
I wish you a very nice Christmas !
gersende
Dec 21 2021 02:40 AM
Dec 13 2021 07:06 AM
SolutionHi @gerse21
instead of standard Pivot filters I propose that you use slicers:
For every field that you need to filter, you can insert a slicer. They are much more user friendly and if you have filtered one field with a slicer, the slicers for the other fields just show the relevant options.