Pivot Table formatting

[Curtis Finney]

I am using a pivot table to group a bunch of data. Let's
say I have three columns of data going into the pivot
table. Color, ID, Amount. I would like the output to be
grouped by Color, count of ID, and sum of amount. I would
like the count and amount results to be their own
columns. The wizard always makes these separate rows
within each color row. This makes it very hard to analyze
the data. Can someone help me out?

 

[Curtis Finney]

Thanks! I knew it had to be something easy. I had been
banging my head on that one for a long time.

-----Original Message-----
Try this:

Click on the grey button that says "Data" and drag across

and up to the column heading area then release.