Hello all,
CR+CE9,SQL2K
I have a cross tab that is to display number and percentage of loan applications over a 16 week period, the columns are bands which represent the number of days between date of application and date of loan approval. The rows are the weeks in which the loans were applied for. So it would look something like:
2-4days 5-10days 11-16days
week1 2 8 5
13.33% 53.33% 33.33%
week2 10 2 6
55.55% 11.11% 33.33%
.
Total 12 10 11
36.36% 30.30% 33.33%
What are also need is the max and min percentages over all the weeks, so in the above example, the last two rows would be:
Max 55.55% 53.33% 33.33%
Min 13.33% 11.11% 33.33%
I am struggling how to work out how to do this. The data is sent to Crystal as one account per row, with the relevant application dates to put them into the correct cross tab row.
I hope someone can help
mrees
CR+CE9,SQL2K
I have a cross tab that is to display number and percentage of loan applications over a 16 week period, the columns are bands which represent the number of days between date of application and date of loan approval. The rows are the weeks in which the loans were applied for. So it would look something like:
2-4days 5-10days 11-16days
week1 2 8 5
13.33% 53.33% 33.33%
week2 10 2 6
55.55% 11.11% 33.33%
.
Total 12 10 11
36.36% 30.30% 33.33%
What are also need is the max and min percentages over all the weeks, so in the above example, the last two rows would be:
Max 55.55% 53.33% 33.33%
Min 13.33% 11.11% 33.33%
I am struggling how to work out how to do this. The data is sent to Crystal as one account per row, with the relevant application dates to put them into the correct cross tab row.
I hope someone can help
mrees