I'm stuck in my dashboard view. Any help would be well appreciated.
I have a table which shows weekly sales numbers segregated into each date
|19th Aug||20th Aug||21st Aug||22nd Aug||23rd Aug||24th Aug||25th Aug|
I have a separate table which shows MTD number. So if a user selects 19th - 25th week, MTD number would reflect 1st Aug to 25th Aug data.
Since the user has an option to select any week, say 12th - 18th Aug or 5th to 11th Aug, I want my MTD number to change accordingly.
It would help if you provided some sample data from your tables and some mention of the data source of these tables