multiple results display after filter function

TYPE RATE MAT AMT FLOOR CAP OFFSET
9 6.00% Jul-05 10 4.00% 19.00% 0.25
2 2.00% Aug-06 50 4.00% 20.00% 0.50
2 7.00% Dec-13 110 4.00% 15.00% 1.00
5 3.00% Jan-09 50 4.00% 18.00% 1.00
4 5.00% Feb-06 5 1.00
3 5.00% Oct-09 20 2.00% 18.00% 3.00
4 6.00% Aug-10 10 3.00
4 5.00% Oct-11 10 4.00% 18.00%
4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
5 6.00% Jul-11 2 2.00
6 2.00% Aug-06 25 5.00% 19.00%
5 8.00% Oct-20 100 1.00
3 5.00% Nov-06 12 2.00% 15.00%
2 4.00% Jan-09 20 5.00% 15.00%
1 6.00% Jan-06 2,000 4.00% 19.00%
1 5.00% Feb-09 3,000 5.00% 20.00%
9 5.00% Aug-06 5 3.00% 20.00% 2.00
8 4.00% Oct-05 9 5.00% 15.00% 1.00
9 6.00% Jul-05 10 4.00% 19.00% 0.25
2 2.00% Aug-06 50 4.00% 20.00% 0.50
2 7.00% Dec-13 110 4.00% 15.00% 1.00
5 3.00% Jan-09 50 4.00% 18.00% 1.00
4 5.00% Feb-06 5 1.00
3 5.00% Oct-09 20 2.00% 18.00% 3.00
4 6.00% Aug-10 10 3.00
4 5.00% Oct-11 10 4.00% 18.00%
4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
5 6.00% Jul-11 2 2.00
6 2.00% Aug-06 25 5.00% 19.00%
5 8.00% Oct-20 100 1.00
3 5.00% Nov-06 12 2.00% 15.00%
2 4.00% Jan-09 20 5.00% 15.00%
1 6.00% Mar-06 4,000 4.00% 19.00%
1 5.00% Feb-08 1,250 5.00% 20.00%
9 5.00% Aug-06 5 3.00% 20.00% 2.00
8 4.00% Oct-05 9 5.00% 15.00% 1.00
9 6.00% Jul-05 10 4.00% 19.00% 0.25
2 2.00% Aug-06 50 4.00% 20.00% 0.50
2 7.00% Dec-13 110 4.00% 15.00% 1.00
5 3.00% Jan-09 50 4.00% 18.00% 1.00
4 5.00% Feb-06 5 1.00
3 5.00% Oct-09 20 2.00% 18.00% 3.00
4 6.00% Aug-10 10 3.00
4 5.00% Oct-11 10 4.00% 18.00%
4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
5 6.00% Jul-11 2 2.00
6 2.00% Aug-06 25 5.00% 19.00%
5 8.00% Oct-20 100 1.00
3 5.00% Nov-06 12 2.00% 15.00%
2 4.00% Jan-09 20 5.00% 15.00%
1 6.00% Jan-06 3,201 4.00% 19.00%
1 5.00% Feb-08 2,000 5.00% 20.00%
9 5.00% Aug-06 5 3.00% 20.00% 2.00
8 4.00% Oct-05 9 5.00% 15.00% 1.00
9 6.00% Jul-05 10 4.00% 19.00% 0.25
2 2.00% Aug-06 50 4.00% 20.00% 0.50
2 7.00% Dec-13 110 4.00% 15.00% 1.00
5 3.00% Jan-09 50 4.00% 18.00% 1.00
4 5.00% Feb-06 5 1.00
3 5.00% Oct-09 20 2.00% 18.00% 3.00
4 6.00% Aug-10 10 3.00
4 5.00% Oct-11 10 4.00% 18.00%
4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
5 6.00% Jul-11 2 2.00
6 2.00% Aug-06 25 5.00% 19.00%
5 8.00% Oct-20 100 1.00
3 5.00% Nov-06 12 2.00% 15.00%
2 4.00% Jan-09 20 5.00% 15.00%
1 6.00% Jan-06 2,000 5.00% 19.00%
1 5.00% Feb-08 3,000 5.00% 20.00%
9 5.00% Aug-06 5 3.00% 20.00% 2.00
8 4.00% Oct-05 9 5.00% 15.00% 1.00
9 6.00% Jul-05 10 4.00% 19.00% 0.25
2 2.00% Aug-06 50 4.00% 20.00% 0.50
2 7.00% Dec-13 110 4.00% 15.00% 1.00
5 3.00% Jan-09 50 4.00% 18.00% 1.00
4 5.00% Feb-06 5 1.00
3 5.00% Oct-09 20 2.00% 18.00% 3.00
4 6.00% Aug-10 10 3.00
4 5.00% Oct-11 10 4.00% 18.00%
4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
5 6.00% Jul-11 2 2.00
6 2.00% Aug-06 25 5.00% 19.00%
5 8.00% Oct-20 100 1.00
3 5.00% Nov-06 12 2.00% 15.00%
2 4.00% Jan-09 20 5.00% 15.00%
1 6.00% Mar-06 4,000 4.00% 19.00%
1 5.00% Feb-08 1,250 5.00% 20.00%
9 5.00% Aug-06 5 3.00% 20.00% 2.00
8 4.00% Oct-05 9 5.00% 15.00% 1.00
9 6.00% Jul-05 10 4.00% 19.00% 0.25
2 2.00% Aug-06 50 4.00% 20.00% 0.50
2 7.00% Dec-13 110 4.00% 15.00% 1.00



TYPE 9 RESULTS
6.00% Jan-06 7,201 4.28% 19.00% TYPE 9
4 5.00% Feb-08 7,500 5.00% 20.00% TYPE 9
1 5.00% Feb-09 3,000 5.00% 20.00% TYPE 9
2 6.00% Mar-06 8,000 4.00% 19.00% TYPE 9



398 6.21% $38,061.00 4.00% 18.63% Total

Good Morning Folks...
I will try my best to explain this. When you filter this the TYPE will show
all the options in the drop down combo box. So far what I able to solve is
that when select TYPE (let say for example TYPE 1), it will display the TYPE
1 related totals and weighted averages. Here is the result:
TYPE RATE MAT AMT FLOOR CAP OFFSET
1 6.00% Jan-06 2,000 4.00% 19.00%
1 5.00% Feb-09 3,000 5.00% 20.00%
1 6.00% Mar-06 4,000 4.00% 19.00%
1 5.00% Feb-08 1,250 5.00% 20.00%
1 6.00% Jan-06 3,201 4.00% 19.00%
1 5.00% Feb-08 2,000 5.00% 20.00%
1 6.00% Jan-06 2,000 5.00% 19.00%
1 5.00% Feb-08 3,000 5.00% 20.00%
1 6.00% Mar-06 4,000 4.00% 19.00%
1 5.00% Feb-08 1,250 5.00% 20.00%


10 5.59% $25,701.00 4.49% 19.41% Total

Now what I'm after is I like to see the result (which is further filter my
MAT date) and should display at the same time. The result should be :

TYPE RATE MAT AMT FLOOR CAP OFFSET
1 6.00% Jan-06 2,000 4.00% 19.00%
1 5.00% Feb-09 3,000 5.00% 20.00%
1 6.00% Mar-06 4,000 4.00% 19.00%
1 5.00% Feb-08 1,250 5.00% 20.00%
1 6.00% Jan-06 3,201 4.00% 19.00%
1 5.00% Feb-08 2,000 5.00% 20.00%
1 6.00% Jan-06 2,000 5.00% 19.00%
1 5.00% Feb-08 3,000 5.00% 20.00%
1 6.00% Mar-06 4,000 4.00% 19.00%
1 5.00% Feb-08 1,250 5.00% 20.00%



TYPE 1 RESULTS
3 6.00% Jan-06 7,201 4.28% 19.00% TYPE 1
4 5.00% Feb-08 7,500 5.00% 20.00% TYPE 1
1 5.00% Feb-09 3,000 5.00% 20.00% TYPE 1
2 6.00% Mar-06 8,000 4.00% 19.00% TYPE 1



10 5.59% $25,701.00 4.49% 19.41% Total

I really need help in this regard. Will really appreciate your input in this
matter.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200508/1

Morphyus C wrote:
>TYPE RATE MAT AMT FLOOR CAP OFFSET
>9 6.00% Jul-05 10 4.00% 19.00% 0.25
>2 2.00% Aug-06 50 4.00% 20.00% 0.50
>2 7.00% Dec-13 110 4.00% 15.00% 1.00
>5 3.00% Jan-09 50 4.00% 18.00% 1.00
>4 5.00% Feb-06 5 1.00
>3 5.00% Oct-09 20 2.00% 18.00% 3.00
>4 6.00% Aug-10 10 3.00
>4 5.00% Oct-11 10 4.00% 18.00%
>4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
>5 6.00% Jul-11 2 2.00
>6 2.00% Aug-06 25 5.00% 19.00%
>5 8.00% Oct-20 100 1.00
>3 5.00% Nov-06 12 2.00% 15.00%
>2 4.00% Jan-09 20 5.00% 15.00%
>1 6.00% Jan-06 2,000 4.00% 19.00%
>1 5.00% Feb-09 3,000 5.00% 20.00%
>9 5.00% Aug-06 5 3.00% 20.00% 2.00
>8 4.00% Oct-05 9 5.00% 15.00% 1.00
>9 6.00% Jul-05 10 4.00% 19.00% 0.25
>2 2.00% Aug-06 50 4.00% 20.00% 0.50
>2 7.00% Dec-13 110 4.00% 15.00% 1.00
>5 3.00% Jan-09 50 4.00% 18.00% 1.00
>4 5.00% Feb-06 5 1.00
>3 5.00% Oct-09 20 2.00% 18.00% 3.00
>4 6.00% Aug-10 10 3.00
>4 5.00% Oct-11 10 4.00% 18.00%
>4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
>5 6.00% Jul-11 2 2.00
>6 2.00% Aug-06 25 5.00% 19.00%
>5 8.00% Oct-20 100 1.00
>3 5.00% Nov-06 12 2.00% 15.00%
>2 4.00% Jan-09 20 5.00% 15.00%
>1 6.00% Mar-06 4,000 4.00% 19.00%
>1 5.00% Feb-08 1,250 5.00% 20.00%
>9 5.00% Aug-06 5 3.00% 20.00% 2.00
>8 4.00% Oct-05 9 5.00% 15.00% 1.00
>9 6.00% Jul-05 10 4.00% 19.00% 0.25
>2 2.00% Aug-06 50 4.00% 20.00% 0.50
>2 7.00% Dec-13 110 4.00% 15.00% 1.00
>5 3.00% Jan-09 50 4.00% 18.00% 1.00
>4 5.00% Feb-06 5 1.00
>3 5.00% Oct-09 20 2.00% 18.00% 3.00
>4 6.00% Aug-10 10 3.00
>4 5.00% Oct-11 10 4.00% 18.00%
>4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
>5 6.00% Jul-11 2 2.00
>6 2.00% Aug-06 25 5.00% 19.00%
>5 8.00% Oct-20 100 1.00
>3 5.00% Nov-06 12 2.00% 15.00%
>2 4.00% Jan-09 20 5.00% 15.00%
>1 6.00% Jan-06 3,201 4.00% 19.00%
>1 5.00% Feb-08 2,000 5.00% 20.00%
>9 5.00% Aug-06 5 3.00% 20.00% 2.00
>8 4.00% Oct-05 9 5.00% 15.00% 1.00
>9 6.00% Jul-05 10 4.00% 19.00% 0.25
>2 2.00% Aug-06 50 4.00% 20.00% 0.50
>2 7.00% Dec-13 110 4.00% 15.00% 1.00
>5 3.00% Jan-09 50 4.00% 18.00% 1.00
>4 5.00% Feb-06 5 1.00
>3 5.00% Oct-09 20 2.00% 18.00% 3.00
>4 6.00% Aug-10 10 3.00
>4 5.00% Oct-11 10 4.00% 18.00%
>4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
>5 6.00% Jul-11 2 2.00
>6 2.00% Aug-06 25 5.00% 19.00%
>5 8.00% Oct-20 100 1.00
>3 5.00% Nov-06 12 2.00% 15.00%
>2 4.00% Jan-09 20 5.00% 15.00%
>1 6.00% Jan-06 2,000 5.00% 19.00%
>1 5.00% Feb-08 3,000 5.00% 20.00%
>9 5.00% Aug-06 5 3.00% 20.00% 2.00
>8 4.00% Oct-05 9 5.00% 15.00% 1.00
>9 6.00% Jul-05 10 4.00% 19.00% 0.25
>2 2.00% Aug-06 50 4.00% 20.00% 0.50
>2 7.00% Dec-13 110 4.00% 15.00% 1.00
>5 3.00% Jan-09 50 4.00% 18.00% 1.00
>4 5.00% Feb-06 5 1.00
>3 5.00% Oct-09 20 2.00% 18.00% 3.00
>4 6.00% Aug-10 10 3.00
>4 5.00% Oct-11 10 4.00% 18.00%
>4 8.00% Feb-15 2,000 3.00% 18.00% 2.00
>5 6.00% Jul-11 2 2.00
>6 2.00% Aug-06 25 5.00% 19.00%
>5 8.00% Oct-20 100 1.00
>3 5.00% Nov-06 12 2.00% 15.00%
>2 4.00% Jan-09 20 5.00% 15.00%
>1 6.00% Mar-06 4,000 4.00% 19.00%
>1 5.00% Feb-08 1,250 5.00% 20.00%
>9 5.00% Aug-06 5 3.00% 20.00% 2.00
>8 4.00% Oct-05 9 5.00% 15.00% 1.00
>9 6.00% Jul-05 10 4.00% 19.00% 0.25
>2 2.00% Aug-06 50 4.00% 20.00% 0.50
>2 7.00% Dec-13 110 4.00% 15.00% 1.00
>
>
>TYPE 9 RESULTS
> 6.00% Jan-06 7,201 4.28% 19.00% TYPE 9
>4 5.00% Feb-08 7,500 5.00% 20.00% TYPE 9
>1 5.00% Feb-09 3,000 5.00% 20.00% TYPE 9
>2 6.00% Mar-06 8,000 4.00% 19.00% TYPE 9
>
>
>
>398 6.21% $38,061.00 4.00% 18.63% Total
>
>Good Morning Folks...
>I will try my best to explain this. When you filter this the TYPE will show
>all the options in the drop down combo box. So far what I able to solve is
>that when select TYPE (let say for example TYPE 1), it will display the TYPE
>1 related totals and weighted averages. Here is the result:
>TYPE RATE MAT AMT FLOOR CAP OFFSET
>1 6.00% Jan-06 2,000 4.00% 19.00%
>1 5.00% Feb-09 3,000 5.00% 20.00%
>1 6.00% Mar-06 4,000 4.00% 19.00%
>1 5.00% Feb-08 1,250 5.00% 20.00%
>1 6.00% Jan-06 3,201 4.00% 19.00%
>1 5.00% Feb-08 2,000 5.00% 20.00%
>1 6.00% Jan-06 2,000 5.00% 19.00%
>1 5.00% Feb-08 3,000 5.00% 20.00%
>1 6.00% Mar-06 4,000 4.00% 19.00%
>1 5.00% Feb-08 1,250 5.00% 20.00%
>
>10 5.59% $25,701.00 4.49% 19.41% Total
>
>Now what I'm after is I like to see the result (which is further filter my
>MAT date) and should display at the same time. The result should be :
>
>TYPE RATE MAT AMT FLOOR CAP OFFSET
>1 6.00% Jan-06 2,000 4.00% 19.00%
>1 5.00% Feb-09 3,000 5.00% 20.00%
>1 6.00% Mar-06 4,000 4.00% 19.00%
>1 5.00% Feb-08 1,250 5.00% 20.00%
>1 6.00% Jan-06 3,201 4.00% 19.00%
>1 5.00% Feb-08 2,000 5.00% 20.00%
>1 6.00% Jan-06 2,000 5.00% 19.00%
>1 5.00% Feb-08 3,000 5.00% 20.00%
>1 6.00% Mar-06 4,000 4.00% 19.00%
>1 5.00% Feb-08 1,250 5.00% 20.00%
>
>
>TYPE 1 RESULTS
>3 6.00% Jan-06 7,201 4.28% 19.00% TYPE 1
>4 5.00% Feb-08 7,500 5.00% 20.00% TYPE 1
>1 5.00% Feb-09 3,000 5.00% 20.00% TYPE 1
>2 6.00% Mar-06 8,000 4.00% 19.00% TYPE 1
>
>
>
>10 5.59% $25,701.00 4.49% 19.41% Total
>
>I really need help in this regard. Will really appreciate your input in this
>matter.


CAN SOMEONE PLEASE HELP ME ON THIS ISSUE????


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200508/1