Calendar with Week of the Month

[#1]

Good Day,

     I have a problem showing the Week of each Month, If there a  multiple Selection of month i need to show the week of them on a bar chart,

not the summary of each month, Becuase its a Drill Down.

Regards,

raem.paks

[Jason_Michaelides]

So you want to return a number that is always between 1 and 5 inclusive?

Have you tried (in the script):

Floor(Day(Date)/7)+1     AS     Week

Hope this helps,

Jason