How to derive the MTD achievement based on monthly target and daily sales data on various dimensions

Derive monthly closing balance of various items from yearly opening balance and their monthly transactions data

How to derive the recently purchased city of each customer from daily customer transactions from various cities