Filter on Pivot Table (Excel 365)

New Contributor

Hello,

Do you know how to put the filter in the second line on the pivot table especially when there are 2 fields in column ?

 

Columbo92_0-1639687534096.png

 

Thank you

7 Replies

@Columbo92 The picture isn't very clear, but perhaps you mean that you want a filter button on the last row of the table headers, as shown in the pictures below.

Screenshot 2021-12-17 at 06.17.21.png

 

Screenshot 2021-12-17 at 06.17.51.png

If this is the case, then select the cell to the right of "Grand Total" (i.e. outside the pivot table) and put on the Filter. 

Screenshot 2021-12-17 at 06.21.53.png

Hi @Riny_van_Eekelen ,

 

This technic doesn't work when you have 2 fields in column on the pivot table

 

Columbo92_0-1639729247256.png

 

@Columbo92 Indeed! Too bad, but perhaps there are other ways to achieve what you want. what exactly is it that you want to filter?

Hi @Riny_van_Eekelen 

 

I would like to put the filter in line 8 instead of 6

 

Columbo92_0-1639731313949.png

 

@Columbo92 I understood that, and my trick, indeed doesn't work for this, but what is it that you are trying to do with the filter? Amounts above or below a certain target? Or do you want to be able to sort on a particular column? It seems you are doing some sort of Accounts Receivable analysis by age category. Not sure what the Split is though. You don't show anything of the rest of the pivot table, so it's difficult to help.

In other words, if your question is simply "Can I get a filter button on row 8 in the pivot table?". The answer is no. End of story. If you can describe the underlying issue, like why you need the filter button on row 8, perhaps I or someone else can help.

Hi @Riny_van_Eekelen,

 

"f your question is simply "Can I get a filter button on row 8 in the pivot table?". The answer is no. End of story

This is to put the filter and order the data as I want per column.

Before Excel 365, it was possible with the previous version.

I don't understand why we can't do it now with upgrade version of Excel

@Columbo92 Can't remember it ever worked like that. Sorry!