help with pivot table please

R

rodchar

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top