I just wanna share a strange requirement which i faced in developing a dashboard.
The requirement is stated below,
Display Dates for,
•Selected Date = 21 Nov 13
•Previous 4 days = 20 Nov 13 to 17 Nov 13
•Previous month Selected date = 21 Oct 13
I have implemented this requirement by using multiple Vlookup’s.
you can find the implementation process from the source file attached.
Open the attached file with dashboards(.xlf extension )