Good Afternoon,
My team has been working on a problem for quite sometime now using a large data set, but after numerous attempts but no success of developing results quickly we put together an example in excel. There are 2 data sources attached which include test cost information and unit information. The excel sheet attached also includes those sheets, but our desired outcomes are in the sheet named "Results" and the calculations are behind those results are in the sheet "Calculations".
Our issue is that the costs are at a Cost Type level while our units are at a higher level.
There are 3 different desired outcomes...
1) Unit Cost by Cost Type and Company and Month
Essentially each line should just be the total cost for that cost type for that month, by the total units for the month.
2) Unit Cost by Company and Month
The same as 1, but cost type is taken out of the equation, this is a sum of the costs for a whole month by company divided by total units for that month.
3) Year to Date Unit Cost by Cost Type and Company
Just a sum of the total costs by cost type regardless of month, divided by the sum of all the units for each month.
If anyone could help us solve our problem in Alteryx we would be so appreciative, because our real data source is over 50,000,000 lines of data.
Thank you,
Justin
