Forum Discussion
Cost calculation from Bottomup
If you have vol. and cost column in your table use Sumx
Total_Cost:=(Table,[vol]*[cost]). This should end up as supposed.
Due to company restrictions I am not able to check out your provided link.
So maybe just some information of your data structure would be fine.
Best regards.
The source data's are in 2 different table. I couldnt connect those using Sumx for some reason, although the tables are connected via relation.
Data would look like below:
YearMonthChannelSKUValueMeasure
2017 1 Rural AAA 57 Volume 2017 2 Rural AAA 51 Volume 2017 3 Rural AAA 56 Volume 2017 4 Rural AAA 39 Volume 2017 5 Rural AAA 51 Volume 2017 6 Rural AAA 51 Volume 2017 7 Rural AAA 57 Volume 2017 8 Rural AAA 53 Volume 2017 9 Rural AAA 46 Volume 2017 10 Rural AAA 46 Volume 2017 11 Rural AAA 56 Volume 2017 12 Rural AAA 38 Volume YearMonthSKUSCC.Ton
2017 1 AAA 11 2017 2 AAA 13 2017 3 AAA 14 2017 4 AAA 15 2017 5 AAA 10 2017 6 AAA 14 2017 7 AAA 17 2017 8 AAA 18 2017 9 AAA 11 2017 10 AAA 15 2017 11 AAA 18 2017 12 AAA 10 2017 1 AAB 17 2017 2 AAB 18 2017 3 AAB 16 2017 4 AAB 16 2017 5 AAB 14 2017 6 AAB 17 2017 7 AAB 16 2017 8 AAB 14 2017 9 AAB 17 2017 10 AAB 18 2017 11 AAB 18 2017 12 AAB 16 Can you add headings please.
How did you relate the tables?
When I pasted table, the header disappeared for some reason. Pasted again..
Year Month SKU SCC.Ton2017 1 AAA 11 2017 2 AAA 13 2017 3 AAA 14 2017 4 AAA 15 2017 5 AAA 10 2017 6 AAA 14 2017 7 AAA 17 2017 8 AAA 18 2017 9 AAA 11 2017 10 AAA 15 2017 11 AAA 18 2017 12 AAA 10 2017 1 AAB 17 2017 2 AAB 18 2017 3 AAB 16 2017 4 AAB 16 2017 5 AAB 14 2017 6 AAB 17 2017 7 AAB 16 2017 8 AAB 14 2017 9 AAB 17 2017 10 AAB 18 2017 11 AAB 18 2017 12 AAB 16 Year Month Channel SKU Value Measure
2017 1 Rural AAA 57 Volume 2017 2 Rural AAA 51 Volume 2017 3 Rural AAA 56 Volume 2017 4 Rural AAA 39 Volume 2017 5 Rural AAA 51 Volume 2017 6 Rural AAA 51 Volume 2017 7 Rural AAA 57 Volume 2017 8 Rural AAA 53 Volume 2017 9 Rural AAA 46 Volume 2017 10 Rural AAA 46 Volume 2017 11 Rural AAA 56 Volume 2017 12 Rural AAA 38 Volume 2017 1 Rural AAB 49 Volume 2017 2 Rural AAB 31 Volume 2017 3 Rural AAB 41 Volume 2017 4 Rural AAB 52 Volume 2017 5 Rural AAB 35 Volume 2017 6 Rural AAB 37 Volume 2017 7 Rural AAB 57 Volume 2017 8 Rural AAB 59 Volume 2017 9 Rural AAB 58 Volume 2017 10 Rural AAB 54 Volume 2017 11 Rural AAB 49 Volume 2017 12 Rural AAB 45 Volume U created distinct table for SKU/Product, Month , Year etc to related the tables.
