SOLVED

pivot table

New Contributor

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

3 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

Hi @gerse21 

 

instead of standard Pivot filters I propose that you use slicers:

DTE_0-1639407903272.png

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.

@DTE 

 

Thank you so much !

it's exactly what I needed !

 

I wish you a very nice Christmas !

 

gersende

 

Hi @gerse21 

 

I'm glad to hear that it helped.

 

I wish also Merry Christmas to you!

 

Martin