To Display Data for 4 Previous Days from Selected Date & Previous Month Data of Selected Date in Dashboards

Hello All,

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 )

Best Regards,

Samatha B.