PIVOT HELP

C

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
 
R

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.
 
C

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
 
R

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.
 

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

Similar Threads

Cumulative time calculation in Excel 2003 3
Which functions and Procedure to use to have desired result? 0
relective formula 0
Assistance in modifying a formula 0
scatter plot 2
repeated conversion of data summarized into rows and columns 4
Using SUMPROD and trying SUBSTITUTE, ELIMINATE or TAKE the last VE 0
Sorting and maintaining formula integrity 5

Top