Display Dates in Time Filter...

Hi,

Has anyone tried to Display date labels below Time filter? Something like, Time filter shows YTD below that it has to show the date labels of YTD period. Same like that for QTD, MTD, WTD...

Also, this has to change as and when the incremental refresh happens.

I tried using, the below logic but my net sales is getting affected easily as am joining this with my custom sql query used to create dashboard.

select 'LD' as agg_type ,min(date_fld) as st_date_fld,max(date_fld) as end_date_fld from dim_date where last_x_day=1

UNION ALL

select 'WTD' as agg_type ,min(date_fld) as st_date_fld,max(date_fld) as end_date_fld from dim_date where last_x_week=1 and date_fld<=current_date-1

UNION ALL

select 'MTD' as agg_type ,min(date_fld) as st_date_fld,max(date_fld) as end_date_fld from dim_date where last_x_month=1 and date_fld<=current_date-1

UNION ALL

select 'YTD' as agg_type ,min(date_fld) as st_date_fld,max(date_fld) as end_date_fld from dim_date where last_x_year=1 and date_fld<=current_date-1

Thanks,

Swetha Dinesh