Solved

Excel 2010: Pivot Tables - sorting and filtering

Posted on 2014-03-18
1
795 Views
Last Modified: 2014-03-21
I'm new to creating pivot tables, not new to databases and spreadsheets.
I have  a sheet that contains:
Group
subGroup
Product Count
Product Cost
Product Price



I wish to create a sheet (I'm assuming a pivot table, I think) that looks like:

  A                B                    C                         D                 E
Group   SubGroup  ProductCount  ProdcutCost ProductPrice



columns C, D, E are sums.  Those sound like Values in a Pivot Table.
I would like column A and B to be filterable. That sounds like Row Labels.
I would also like the ability to sort on C D or E
If I make the pivot table and try sorting C, it does sort C, but doesnt take the rest of the table
with it.  How do I make this easy?



If I make A & B row labels, I get ALL of A (fine with me) and a line by line of B (not fine with me)
I would like to have the ablity to expand the B column, but not have it show All B's so that I
manually have to go through the 2000+ subgroups and collapse them
Is there any way to do this?

Perhaps I dont need a pivot at all, but more of a pulldown for each original sheet column that allows
filtering and sorting....how would I do that?
0
Comment
Question by:GNOVAK
1 Comment
 
LVL 19

Accepted Solution

by:
regmigrant earned 500 total points
ID: 39938354
it sounds like you just need to layout the column heading as you defined with relevant formulas for the sum then use autofilter. it will filter the way you describe and also has a sort option in the drop down.

A pivot table works by grouping data under a heading and the hierarchy is fixed from left to right so column b must always be subordinate to column A.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now