I want to create a dashboad with 3 frames. Data is stored in datetime basis
Selection filter will be on the basis if current week , ie week number as of today. You can filter on previous week data also.
on selection of any week number,
first frame should display current week
Second frame is : daily data belong to the week selected
frame 3 : Previous 4 weeks data from the selected week
frame 4: monthly data of the selected week.
All data should be summarised weekly data
Thanks and regards
In order to help build something like this, we're going to need to see a packaged workbook showing the work you've already tried. If you've found an answer, please share!