Excel 2010: Pivot Tables - sorting and filtering
Posted on 2014-03-18
I'm new to creating pivot tables, not new to databases and spreadsheets.
I have a sheet that contains:
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?