Pivot table question: Sorting the subgroup in a pivot table (whenusing the top 10 option for the sub

M

Mike C

Hello:
I have created a pivot table which has a one subgroup in the second
column from the left. It uses the Top 10 option, so there are 10
subgroups

So my data looks something like this:

Group 1 50
Subgroup 1a 10
Subgroup 1b 40
Eight more subgroups

Group 2 30
Subgroup 2a 20
Subgroup 2b 10
Eight more subgroups

What I would like to do is sort by THe totals for Group 1, but then
also sort by the subgroups, based on the values for each subgroup
(similar to the "Sort by, then by.." option in a normal table).

So, the top 10 Groups will show up at the top, and then the subgroups
will also be sorted descending.

Does anyone know how I can accomplish this?

Thanks for any suggestions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Ascending Subgroup in a Pivot Tables - 2007 0
Sum of sub groups 3
need help making a query (crosstab instead of Pivot tables?) 3
Dealing with a Pivot Table (when I don't want to) 0
Names of individual controls in option group 4
Average of % in pivot table 1
working with pivot tables items 0
display all records within a subgroup in a pivot table without ha. 0

Top