INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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.

Jobs

MS Excel Pivots - Same Data used for Columns and Values

MS Excel Pivots - Same Data used for Columns and Values

MS Excel Pivots - Same Data used for Columns and Values

(OP)
Hi , this must be so straightforward but it's driving me nuts...
I need to evaluate Region, Area and Type in an excel 2010 pivot table.

Aim: I want to group data by Region, and Area in rows.
Then I want to be able to
1)
count occurrences of Type, while
2)
using Type as column Headings, and
3)
to also filter out Types I don't need to count

Should be simple ? Yet I only seem to be able to select the data source for one element.

I.E. Every time I try to set the Type as 'Column Label', it disappears from the other (e.g. 'Values'). Any pointers very gratefully received
Thanks all

WS

RE: MS Excel Pivots - Same Data used for Columns and Values

Shouldn't you be able to "count" any column that has values? I expect you could add another column to the data if needed.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

RE: MS Excel Pivots - Same Data used for Columns and Values

Hi,

Drag Region & Area from the Choose fields area to the ROWS area

Drag the Type from the Choose fields area to the COLUMNS area

Drag the Type from the Choose fields area to the VALUES area and select COUNT of Type if not already selected

Skip,

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

RE: MS Excel Pivots - Same Data used for Columns and Values

(OP)
Thanks SkipVought, that's working fine now
WS

RE: MS Excel Pivots - Same Data used for Columns and Values

WildbloodS,

It's appropriate when a member posts an answer to recognize the post and poster by clicking the "Great Post" link.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

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!

Resources

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