BaconMcSandwich
New Member
- Joined
- Jun 14, 2021
- Messages
- 16
- Office Version
- 365
- Platform
- Windows
I've a list of items and the profit made on each item. I've used this list to create a pivot table showing the items, how many of each were sold the total profit for those items.
I have a seperate set of data that lists how many people called up to enquire about each item. How do I go about combining the two sets of data so that I can see how many enquiries were made for each item in the pivot table? (And thus calculate the ration of enquiries to sales which is the end goal of this)
e.g.
This data is a Pivot Table I have produced from a Table of data listing all sales
This Data is just in excel (could convert to table or do anything else with)
I have a seperate set of data that lists how many people called up to enquire about each item. How do I go about combining the two sets of data so that I can see how many enquiries were made for each item in the pivot table? (And thus calculate the ration of enquiries to sales which is the end goal of this)
e.g.
This data is a Pivot Table I have produced from a Table of data listing all sales
Item | Total Sold | Total Profit | Profit per Unit |
Item1 | 10 | 1000 | 100 |
Item2 | 5 | 1000 | 200 |
Item3 | 20 | 100 | 5 |
This Data is just in excel (could convert to table or do anything else with)
Item | Number of Enquiries |
Item1 | 50 |
Item2 | 5 |
Item3 | 40 |