To Display week based on selection

[ajsjoshua]

Dear all,

I am showing sales value for weeks for ex:Week32 Oct 29 to Nov 04.If an user selects month for ex:nov then it will show only sales value for the month november but my week displays like Week32 Oct 29 to Nov 04.i want to show like     Week32 Nov 01 to Nov 04.I am using fiscal calendar and my week starts from Monday to Sunday.

My calculated dimension:

FiscalWeek &' '&date(WeekStart(CDate),'MMM DD')&' to '&date(WeekEnd(CDate),'MMM DD')

Regards,

Joshua.

[sunny_talwar]

May be try this

FiscalWeek &' '& Date(RangeMax(WeekStart(CDate), Min(CDate)), 'MMM DD') & ' to ' & Date(RangeMin(WeekEnd(CDate), Max(CDate)), 'MMM DD')

[ajsjoshua]

Dear brother,

=FiscalWeek &' '& Date(RangeMax(WeekStart(CDate), Min(CDate)), 'MMM DD') & ' to ' & Date(RangeMin(WeekEnd(CDate), Max(CDate)), 'MMM DD')

I am getting error in calculated dimension.

[sunny_talwar · Accepted solution]

My bad... try this

=FiscalWeek &' '& Date(RangeMax(WeekStart(CDate), Min(TOTAL CDate)), 'MMM DD') & ' to ' & Date(RangeMin(WeekEnd(CDate), Max(TOTAL CDate)), 'MMM DD')