Sorting in Pivot Tables

D

diaare

Please help.

I have a pivot table that displays 07 data vs 08 data.

2007 2008
CATAGORY1 SUBCATAGORY SALES SALES
SUBCATAGORY1 10000 9000
SUBCATAGORY2 0 500
SUBCATAGORY2 500 10
CATAGORY1 Total 10500 9510
SUBCATAGORY1 1000 6000
SUBCATAGORY2 20000 800
SUBCATAGORY2 50 0
CATAGORY2 Total 21050 6800

The above is exactly how it want to be displayed...

first sort the main catagories by the totals of the 08 sales descending,
then, within those, sort the subcatagories by the 08 sales descending.

Everytime I try to sort, it only gives tme the option to sort by the "SUM of
sales" which in turn gives me very different results.

Hope this is clear.

Thanks
Diane
 

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

Pivot Table - Compare Dates & calc. % 1
In Pivot table sort 1
Sorting 2 data columns in Pivot Table 2
pivot tables 0
Pivot Tables in Excel 2007 vs 2003 1
How to sort data in data area in a pivot table 1
Column Heading on each row in pivot table 1
Why aren't dates always available to group in pivot tables? 4

Top