Pivot Table Filters 1

[Cpreston]

Hi

I have created a Pivot Table but only one of my rows allows Filters on the Headings.

I have tried every setting going I can find so I can get the filters on all the headings but cannot find out how to.

As you can see in the attached screen shot only Process type as a filter available. I have tried to do the Pivot again but even that only allows it on the first Coolum. Any ideas please.

 

[SkipVought]

Hi,

Can't work on a pretty picture. That's virtually worthless!

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[Cpreston]

Hi

So what can I provide that you can use to assist me. I thought the picture was good to explain the issue Process Type as a filter, the columns Maine Name, Order, Customer, Source size, Source Grade and process do not have the option. So how do I get it so they have.

 

[SkipVought]

Data not pictures. Pictures cannot be manipulated by Excel features, only DATA.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[Andrzejek]

... like in (missing) attached Excel file with representative DATA

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[Cpreston]

Hi

Ok attached is some sample data, it may complain about trying to connect to a site please ignore this I have taken out all connections.
The main data sheet is called Production Data (Current year) and the pivot is in the Pivot tab. This is just a copy of the real sheet.

Thanks

 

[SkipVought]

Right click your PT.
Select Pivot Table Options
On Display tab select Classical PT display, or words to that effect.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[Cpreston]

Hi

That worked perfect, thanks for the help