This is what I was looking for. Thank you for the video. This is a masterclass.
@aaaexcelenglish Жыл бұрын
Great, Happy that you found what you was looking for, thank you
@Egyptian_Fisher Жыл бұрын
Very insightful
@aaaexcelenglish Жыл бұрын
Thank you 🙏
@mufycw Жыл бұрын
In this video, you calculated total budget by using sum function why you didnt use SUMX function like you did in sales table?
@aaaexcelenglish Жыл бұрын
The structure of the budget table is different, the revenue already calculated unlike the actual, I had to calculate the revenue using quantity and discount from the fact table and the price column from the lookup table