Hi everybody,

I have a table, which I use for Market Share Report.

In this table I have

ccode town Lender RankNumPur RankVolPur NumMtg VolMtg MktShrNum MktShrVol

fields

So each lender is ranked depending on number of mortgages in this particular town/county/state this lender provided.

Market share gives us Number of mortgages for this lender/Total Number of mortgages for all lenders

Here is my when expression in report for printing Lender information:

!empty(RankNumPur) and RankNumPur<>999999 and MksNumPur>=CutOff

where cutoff is either 0.02 for county/state level and 0.5 per town level.

Now my manager wants to change requirement. He wants to print

1 Top Lender per County
3 Top Lenders per State for CT.

My question is: is it possible to somehow re-calculate CutOff variable to use the existing reports with minimum changes?

I can change everything to use RankNumPur<2/4 to print 1/3 top lenders, but this would involve too many changes in the report and its variables. I'm trying to achieve the same result with minimum work...

Could you please suggest something?

Thanks in advance.