Morphyus C via OfficeKB.com
Guest
Re: multiple results display after filter function
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks