Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Consolidate two Data Sets for Making a Report
Hey,
I have two sets of data DataSet1: Materials sold per country along with other information like forcast and inventory. DataSet 2: Material's inventory and production in each factory. Report: I want to make a report which shows materials sold and the inventory and production in each factory. What I am doing: VLOOKUP factory's data in Dataset 1 and making a Pivot Table Problem: When I VLOOKUP the data, if a material is being sold in more than one country the values for factory comes more than once and when I do PIVOT it becomes multiple. Part-Solution: For values of Factory data in PIVOT I displayed Max/Min, that works fine for Material data but when managers need to find data according to Model Type, Model Year or Import then it becomes problem. Kindly suggest me a way out of this, thanks in advance. Incase you need the sample data I can provide you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Consolidate two Data Sets for Making a Report
On Mar 19, 8:42*am, Nano wrote:
Hey, I have two sets of data DataSet1: Materials sold per country along with other information like forcast and inventory. DataSet 2: Material's inventory and production in each factory. Report: I want to make a report which shows materials sold and the inventory and production in each factory. What I am doing: VLOOKUP factory's data in Dataset 1 and making a Pivot Table Problem: When I VLOOKUP the data, if a material is being sold in more than one country the values for factory comes more than once and when I do PIVOT it becomes multiple. Part-Solution: For values of Factory data in PIVOT I displayed Max/Min, that works fine for Material data but when managers need to find data according to Model Type, Model Year or Import then it becomes problem. Kindly suggest me a way out of this, thanks in advance. Incase you need the sample *data I can provide you. "If desired, send your file to dguillett1 @gmail.com I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have workbooks to consolidate data from on one report | Excel Discussion (Misc queries) | |||
How do I Consolidate an EXCEL Report into a record for ACCESS impo | Excel Discussion (Misc queries) | |||
Making a Pivot chart from 3 differnt sets of data / worksheets. | Charts and Charting in Excel | |||
Consolidate report in Different sheet | Excel Discussion (Misc queries) | |||
How do I consolidate 2 tables into 1 pivot report? | Excel Discussion (Misc queries) |