I have an Excel Spreadsheet that I will be adding rows to every month. (this could also be imported into an access database) I would like to analyze and view this data in multiple ways. I am looking for someone who is a pro with Pivot tables and charts (unless you have a better solution). I would like some of the products grouped together. The items to be grouped together will be sent in a separate spreadsheet.
The spreadsheet consists of the following fields:
Ways I would like to see the data:
1. By Product Group Overall
2. By Product Group Monthly
3. By Customer Group – By Product Group Overall
4. By Customer Group – By Product Group Monthly
5. By Sales Rep – By Product Group Overall
6. By Sales Rep – By Product Group Monthly
I would like charts by product – by quantity and by extended amount. I would like to be able to view one month against the next.
However this is developed, it has to be simple enough for me to manipulate after the initial creation. For example, if I want to add a product or customer to a group.
Please contact me via PM with questions/suggestions. I look forward to your replies.
28 pekerja bebas membida secara purata $84 untuk pekerjaan ini
Hello Pamela, like the other guy I am good in MS Excel and also in pivoting. Actally I'm not just good love to manipulate data with pivots. Please refer to PM for a suggestion. Best Regards, Nick
hi i've 5years experience of vb6, access, sql, etc i have developed many project also using charts graphs etc.can send u exe if u r interested i can give u more Better suggestions if u want pls contact.