Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 36
Default 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
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
I have workbooks to consolidate data from on one report jyinlex Excel Discussion (Misc queries) 0 September 21st 09 04:49 PM
How do I Consolidate an EXCEL Report into a record for ACCESS impo Mike M Excel Discussion (Misc queries) 1 September 16th 09 11:28 AM
Making a Pivot chart from 3 differnt sets of data / worksheets. spudsnruf Charts and Charting in Excel 0 September 2nd 09 04:43 PM
Consolidate report in Different sheet Krishna Kumar L Excel Discussion (Misc queries) 3 February 8th 09 01:08 PM
How do I consolidate 2 tables into 1 pivot report? Deb-tasha Excel Discussion (Misc queries) 2 October 5th 06 08:09 AM


All times are GMT +1. The time now is 04:10 PM.

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"