Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table newbie help..
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Filename reference in Spreadsheet XML issue | Excel Discussion (Misc queries) | |||
Display the source for a pivot table page field | Excel Worksheet Functions | |||
Insert a row after a pivot table | Excel Discussion (Misc queries) | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions |