Ad Hoc - Mortgage Company

I need a report listing the mortgage companies--in descending order as to how many transactions we have given to each one, with the company with most transactions at the top.

LIST DA WITH CONTRACT_PERIOD BETWEEN 201001 AND 201012 BY MORTGAGE_VENDOR_NAME BREAK-ON MORTGAGE_VENDOR_NAME TOTAL UNITS

Replace the bold dates with the four digit year and two digit month that you need the report to start and finish in.

**This report cannot be created in descending order in WinMORE. The first few pages are transactions with NO Mortgage Company and they are sorted in Alpha order for mortgage company and then they total the units. You can import this report in Excel, and sort in there to get the report in descending order.