|
The question is, There are 2 fields I care about and an long field, call it an array, made up of 12 months. It contains total # of pieces sold for the item per each month. I don't care about the item I need monthly totals of pieces. I want to take the 2 fields, call them your key, which is the Company, Year, and add a month to them, which I would get from a calc of the long array field. IOW, I want to 'normalize' this file into something I can use during my report. (THE exisiting report has summaries but needs to add this pieces total), summaries by month.
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.