Default Latest Date should be selected when i open a workbook and should drill drown items without human interaction

Hi,

I have one Scenario where i have two work sheet in one dashboard.

• In First worksheet will show you a line graph which includes X axis will be the Date and Y axis will be the time taken by workflow here i need latest top 6 dates and their time taken by workflow.When Ever i open a workbook Default it should be latest Date
• In second worksheet I have sub category wise time taken by workflow. It should be drill down based on latest date from the first worksheet without human interaction.And also When ever i click different dates from latest top 6 dates in  First worksheet  the second worksheet should be drill down