Pivot Table - can't filter items in page area

seyss

New member
Joined
Nov 1, 2013
Messages
1
Reaction score
0
Points
0
Hello,

I need to be able to filter items in the page area of a Pivot Table but I don't see the option.. in other areas such as column or line I see the option as shown in the picture below.

Can anyone help? Best regards.

PS: I can't upgrade my Excel 2003 in my company so I'm stuck with it.

imagem.PNG
 

JoePublic

Super Moderator
Staff member
Joined
Sep 16, 2011
Messages
234
Reaction score
3
Points
18
Location
UK
Excel Version(s)
2016
There is no option for that in any version. Typically page fields/report filters don't have that many items in them.
 

JoePublic

Super Moderator
Staff member
Joined
Sep 16, 2011
Messages
234
Reaction score
3
Points
18
Location
UK
Excel Version(s)
2016
That's what I get for not clicking on the picture! I thought the OP was referring to the caption and value filters (which was daft because they don't exist in 2003!)

In 2003 you have to put the field into the row/column area, select multiple items and then drag it back to the page area, IIRC.
 
Top