Forum Discussion
Cost calculation from Bottomup
Hi Team, I am trying to calculate a cost using bottom up method at monthly level. Where cost would be Vol sold in Month 1, multiplied by Cost in month 1 at Product Level. The total year cost ...
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?