Simple probably. Table has 2 rows 1) Company Name 2) No Months
Delinquent.
Want to write a simple report that gives by company name, Total loans,
Total 0, 1, 2, 3 and over 4 months delinquent. Total of all delinquent
and percentage of each to the whole total.
Sounds simple and probably is but I can't seem to figure it out.
Company Total Total Total Total Total Total
Current 1 Month 2 Month 3 Month Over 4
Company1 11 6 (50%) 2 (20%) 1 (10%) 1 (10%) 1 (10%)
Alignment isn't great but you get the idea. Plus totals overall
Any help would be appreciated.
Jim