Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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