Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with pivot table please
hey all,
i have the following fields and data tableX Sales Rep Name, Amount, Goal Rep1,7.50,10.00 Rep1,5.00,7.50 Rep2,5.00,5.00 i'm trying to create a simple pivot table so it will look like: Rep1 7.50 10.00 5.00 7.50 Total 12.50 15.00 Rep2 5.00 5.00 Total 5.00 5.00 i try to drag rep1 to row area, drop amount field in data area as well as goal in data area but it looks like: Rep1 Sum of Amount 12.50 Sum of Goal 17.50 Rep2 Sum of Amount 5.00 Sum of Goal 5.00 basically, is there a way to move goal next to amount instead of below it? thanks, rodchar |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Print Pivot Table headers on pages with Pivot Table | Excel Worksheet Functions | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) |