Grab the data "button" and drag it to the cell to its immediate left.

Hmmm.

Debra Dalgleish has pictures:
http://contextures.com/xlPivot02.html#Multiple


jholmes_jr wrote:

I have a simple list of Code and Amount. My pivot table looks like this:
CODE
1 Sum of Amount 1,234
Count of Amount 9

2 Sum of Amount 573
Count of Amount 4

What I want is a table that looks like this:
CODE Count Amount
1 9 1,234
2 4 573

This seems like an obvious feature, but I can't figure out how to do it.
Thanks

--

Dave Peterson