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