PIVOT HELP

[CHARI]

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

 

[Roger Govier]

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.

 

[CHARI]

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]

Hi

I'm sorry, a line got missed out of my original posting

On your PT, drag code to the Row area
Drag Amount1 to Data area
Drag Amount 2 to data area

Drag the Data button and drop on Total

You will get the data side by side instead of below each other.