Hello to all,
Here is my data
Bureau Days here are the samples
1 12 (0 - 14 days)
1 13 (15 - 21 days)
1 15 (15 - 21 days)
1 2 (0 - 14 days)
3 49 (22 - 90 days)
3 43 (22 - 90 days)
3 15 (15 - 21 days)
11 12 (0 - 14 days)
11 16 (15 - 21 days)
11 19 (15 - 21 days)
11 17 (15 - 21 days)
11 32 (22 - 90 days)
31 17 (15 - 21 days)
31 90 (22 - 90 days)
31 91 (91 - overdays)
31 98 (91 - overdays)
I am trying to produce a report as show below.
Total Days
Bureau 0 - 14 days 15 - 21 days 22 - 90 days 91 - overdays
1 2 2 0
0
3 0 1 2
0
11 1 3 1
0
31 1 1 1
2
can anyone help me out.
thanks a bunch