LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 216
Default Need suggestions on layout to report/pivot

Does anyone have any thoughts on how to arrange this in Excel 2003:

I have a group of invoice numbers.
I have columns of inforamtion relating to the invoice: inv #, total amount,
inv date, etc.
That is currently set up with the numbers in the first column and the rest
of the information in the columns next to it. So, if I have 1000 invoices, I
have 1000 rows of data.
Now I need to make payments against those rows. Each invoice can have
anywhere from 1-20 payments made against it. For these payments, I need to
record the payment date, the # hrs being paid, the amount being paid, and the
payment number (1-20).

Does anyone have any thoughts on how to arrange the data without having 4
columns for each of the 20 payments totaling 80 columns? I need to be able
to report and pivot off this data. Thanks for any suggestions.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need suggestions on layout to report/pivot Nadine Excel Discussion (Misc queries) 5 May 11th 10 04:07 PM
Pivot Table Layout SusanIT Excel Discussion (Misc queries) 0 October 1st 08 09:09 PM
pivot layout Light Excel Discussion (Misc queries) 2 May 3rd 06 01:46 PM
Pivot Table Layout TimC Setting up and Configuration of Excel 2 January 30th 06 11:55 PM
Pivot Table Layout Help mardman Excel Discussion (Misc queries) 1 August 23rd 05 10:26 PM


All times are GMT +1. The time now is 03:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"