Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Putting Pivot Table Sum and Count on Same Row
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Putting Pivot Table Sum and Count on Same Row
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|