Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table showing totals vertically
I have data which is 3 columns
Emp no Hours Amount When I create a pivot table I get the output below emp no Data Total 536 Sum of hours 111 Sum of amount 4982.36 549 Sum of hours 79 Sum of amount 3336.51 550 Sum of hours 64 Sum of amount 2620.28 What I would like to see instead is Emp No Hours Amount 536 111 4982.36 549 79 3336.51 550 64 2620.28 Am I just dragging my hours and amount into the wrong area of the pivot table or is there something else I need to do? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table showing totals vertically
emp no Data Total
536 Sum of hours 111 Sum of amount 4982.36 etc In the pivot, just drag "Data" and drop over "Total", and it should return the desired results: Emp No Hours Amount 536 111 4982.36 etc -- Max Singapore http://savefile.com/projects/236895 Downloads:20,000 Files:362 Subscribers:62 xdemechanik --- "JBS" wrote: I have data which is 3 columns Emp no Hours Amount When I create a pivot table I get the output below emp no Data Total 536 Sum of hours 111 Sum of amount 4982.36 549 Sum of hours 79 Sum of amount 3336.51 550 Sum of hours 64 Sum of amount 2620.28 What I would like to see instead is Emp No Hours Amount 536 111 4982.36 549 79 3336.51 550 64 2620.28 Am I just dragging my hours and amount into the wrong area of the pivot table or is there something else I need to do? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table showing totals vertically
Take a look at Debra Dalgleish's video:
http://contextures.com/xlVideo001.html JBS wrote: I have data which is 3 columns Emp no Hours Amount When I create a pivot table I get the output below emp no Data Total 536 Sum of hours 111 Sum of amount 4982.36 549 Sum of hours 79 Sum of amount 3336.51 550 Sum of hours 64 Sum of amount 2620.28 What I would like to see instead is Emp No Hours Amount 536 111 4982.36 549 79 3336.51 550 64 2620.28 Am I just dragging my hours and amount into the wrong area of the pivot table or is there something else I need to do? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table showing totals vertically
You guys are fantastic. You have just saved me hours of work. Thanks
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
showing the totals in a chart/table without charting them | Excel Worksheet Functions | |||
Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) | |||
Pivot Table Chart - With Pivot Table Totals | Charts and Charting in Excel | |||
Showing sums horizonatlly, groups vertically | Excel Discussion (Misc queries) | |||
Grand Total on Pivot Table turned on but no totals showing | Excel Discussion (Misc queries) |