Help Requested with Pivot Table

[Jim]

Hi,

I've created a pivot table. It looks like this:

Item1 Sum of Total 9
Count of Names 2
Average of Total 4.5
Item2 Sum of Total 12
Count of Names 3
Average of Total 4
Item3 Sum of Total 3
Count of Names 1
Average of Total 3
.......

You get the idea.
1) I find this to be a very awkward way to present the data. It would
make much more sense to present it as follows:

Name Sum of Count of Average of
Total Names Total
Item1 9 2 4.5
Item2 12 3 4
Item3 3 1 3


So how can I get the data in the pivot to be presented in a way, which
to me, is far more readable?

2) How do I get a Pivot to actually sort based on the data values. For
example, I want to sort the observations so that the observation
(Item3) with the smallest "Sum of Total" actually appears first in the
list.

Thanks for any help that you can provide.



Best Regards, Jim
http://www.marsartgallery.com/

 

[Dave Peterson]

#1. You can drag that grey looking Data button to the right.
Debra Dalgleish shows how:
http://contextures.com/xlPivot02.html#Multiple
and a video!
http://contextures.com/xlVideo001.html

#2. Right click on the Item "Button" header.
Choose Field settings
Click Advanced
choose the Autosort option you want
(Ascending and using field "sum of total")

 

[Jim]

Hello Dave,

#1. You can drag that grey looking Data button to the right.
Debra Dalgleish shows how:
http://contextures.com/xlPivot02.html#Multiple
and a video!
http://contextures.com/xlVideo001.html

Excellent. Worked like a charm.

If only I could have found the answer in Excel's Help.

#2. Right click on the Item "Button" header.
Choose Field settings
Click Advanced
choose the Autosort option you want
(Ascending and using field "sum of total")

Ah, that button. I had tried clicking on the various fields and the
only thing sorting did was to reorder the fields associated with the
items without reordering the items themselves. Following your
instructions, I was able to resort the data the way I wanted to.


Your advice is gold. Many thanks.



Best Regards, Jim
http://www.marsartgallery.com/

 

[Dave Peterson]

Glad it worked for you.

Hello Dave,



Excellent. Worked like a charm.

If only I could have found the answer in Excel's Help.


Ah, that button. I had tried clicking on the various fields and the
only thing sorting did was to reorder the fields associated with the
items without reordering the items themselves. Following your
instructions, I was able to resort the data the way I wanted to.

Your advice is gold. Many thanks.


Best Regards, Jim
http://www.marsartgallery.com/