Hello,
I have a data base where units of products shipped are on a separate line from the cost of making the product.
I'm trying to create a dynamic cost per unit shipped where users can switch from Year <-> Quarter <-> Month
For example CPU for Jan would be (35,000+4,000+45) / 5,000 = $7.89 and for Q1 would be (Jan $ + Feb $ + Mar $) / (5,000 + 4,000 + 7,000) and so on
I've been trying different LOD calculations but to no avail.
Any help would be appreciated. Thank you.
Year Month ItemsCostUnits2018JanMaterial 35,000.00 7,000.00 2018JanPackaging 4,000.00 2,000.00 2018JanLabels 450.00 500.00 2018JanUnits Shipped - 5,000.00 2018FebMaterial 32,500.00 6,500.00 2018FebPackaging 3,000.00 1,500.00 2018FebLabels 270.00 300.00 2018FebUnits Shipped - 4,000.00 2018MarMaterial 47,500.00 9,500.00 2018MarPackaging 8,000.00 4,000.00 2018MarLabels 720.00 800.00 2018MarUnits Shipped - 7,000.00 2018 Apr Material 37,500.00 7,500.00 2018 Apr Packaging 3,800.00 1,900.00 2018 Apr Labels 585.00 650.00 2018 Apr Units Shipped - 5,000.00 2018 May Material 20,000.00 4,000.00 2018 May Packaging 3,000.00 1,500.00 2018 May Labels 180.00 200.00 2018 May Units Shipped - 3,000.00
1 answer
Minchul,
This can achieved through LOD. Please attach a sample workbook for us to work on.
