I have to create a dashboard which includes a filter on time for Week, Month, Quarter and YTD. When ever the user select YTD time filter...dashborad displayes YTD Data (i.e Data till last week ending data).
My Source data has time columns as shown in the below format
Week Ending date
April Week 1
April Week 2
April Week 3
April Week 4
April Week 5
Any one of us please suggest me, is it possible to populate data..when Month selected..particular month data should be displayes..when week selected
..particular week data should displayed..when YTD filter seleted ..data till last week ending date should be displayed...
If possible..please suggest how to achieve this...?