| 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? |
| 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) | |||
Threaded Mode
