results display in filter function
 

Good Morning Folks...
is this possible that multiple related results can be displayed when use
filter functions? For example,
TYPE RATE MAT AMT FLOOR CAP
1 6.00% Jan-06 2,000 4.00% 19.00%
1 5.00% Feb-09 3,000 5.00% 20.00%
2 6.00% Mar-06 4,000 4.00% 19.00%
2 5.00% Feb-08 1,250 5.00% 20.00%
1 6.00% Jan-06 3,201 4.00% 19.00%
if we do filter, TYPE will have two entitities in it. and here is the result:

TYPE RATE MAT AMT FLOOR CAP
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% Jan-06 3,201 4.00% 19.00%
If I further filter this by MAT, I will get two more results by date and thst
is:
TYPE RATE MAT AMT FLOOR CAP
1 6.00% Jan-06 2,000 4.00% 19.00%
1 6.00% Jan-06 3,201 4.00% 19.00%
I'm after if all the results can be displayed at once. Please ask me for
further explanation.
thanks


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