Pivot Table newbie help..

R

robotman

I have a table of several columns of information. In one column there
is an invoice number. In another column the amount for that line of
the invoice. If there are multiple lines for that invoice, there are
multiple rows in the table with the same invoice number.

I know how to create a pivot table, but I'm totally confused on what to
put where in the layout wizard.

1) I want a summary that will show each line of a particular invoice
and then a total for the invoice.

2) I want to add some of the other column information into the table.
For example, the buyer and the invoice date (which would be the same
for multiple lines). I don't need to sum or count these extra fields,
just add it as information to the pivot table. I can't figure how to
do this.

Example (generated from two rows in the source table that had
"Invoice123" as the invoice number).

Invoice123
John Doe 11/9/06 $500
John Doe 11/9/06 $700
Total = $1200

Any help would be appreciated!

Thanks.

John
 
D

Debra Dalgleish

Put the InvoiceNumber, InvoiceDate, Buyer and InvoiceLine fields in the
Row area.

Add the Amount field to the Data area.

To remove subtotals that you don't want, double-click on a field button,
e.g. InvoiceDate --
Under Subtotals, choose None, click OK
 

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