July 30, 2008 at 8:11 am
hi i need to calculate the count of products based on the region but it should group as per the weeks like 1-2 ,3-4.......
source table:
-------------
week region products
-----------------------
1 south 10
1 west 10
2 south 1
3 north 12
4 west 20
5 east 30
6 .. ...................
7
.
...
.....
-------------------------
i need in the below matrix type format
Weeks
lessthan 2 3-4 5-6 7-8 9-10 11-12 >14
Region --------------------------------------------
north 12
east 30
west 10 20
south 11
- ----------------------------------------------------
August 8, 2008 at 2:57 am
to display week as
lessthan 2 3-4 5-6 7-8 9-10 11-12 >14
write iif condition ...if week 3 or 4 thn show as 3-4 and then group it by week ....
this might help u
August 8, 2008 at 8:54 am
you'll need group on the following expression to get the week:
CInt(datediff( day, [first date of report], [date column] ) / 7)+ 1
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply