×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Pivot Table Filters

Pivot Table Filters

Pivot Table Filters

(OP)
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.

RE: Pivot Table Filters

Hi,

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

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: Pivot Table Filters

(OP)
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.

RE: Pivot Table Filters

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

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: Pivot Table Filters

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

---- Andy

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

RE: Pivot Table Filters

(OP)
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

RE: Pivot Table Filters

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

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: Pivot Table Filters

(OP)
Hi

That worked perfect, thanks for the help

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close