WHEN I DRAG BOTH TO THE DATA AREA I GET THEM BELOW EACH OTHER. CAN I GET
THEM IN THE SAME ROW? SEE BELOW SAMPLE

SAMPLE:
ACCT #1 Sum of credit 120278.33
Sum of debit 500.00

"Roger Govier" wrote:

Hi

On your PT, drag code to the Row area
Drag Amount1 to Data area
Drag Amount 2 to data area
You will get the data side by side instead of below each other.

--
Regards
Roger Govier

"CHARI" wrote in message
...
I have a a list of accounts and I have 2 columns of amounts. I need to
create a pivot with the amounts subtotalled for each group.

Ie:

31401 3.00 6.00
31401 2.00 5.00
31600 4.00
31600 10.00

i would like to see 31401 5.00 11.00
31600 0.00 14.00