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 would be Month 1 vol * month 1 cost + Month 2 vol * month 2 cost .... this way.
And the Brand cost would be sum of this from bottom up. However when ever I tried to do it using calculate, the Full year number is Cost of 1 + Cost of 2 ... * total volume, which is incorrect. I am attaching PBI file, can someone guide me on this.
Below is the link
https://1drv.ms/f/s!AuSkszFGzDQzjSL9CxVCzI8VXYGN
13 Replies
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?
