Top N (10) not showing OTHERS - CR XI
Posted on 2006-04-03
I have a report that has mega variables and formuals....it's the ole TR,RR, PS...etc.. report that you've helped me with in the past.
But this is related to my my need to group and subtotal on a formula that consolidates client numbers into GROUPS.
ie. clients 1000,1100,1200 are all WELLS FARGO, and 2000,2200,2300 are all FIDELITY NATIONAL.
All I'm doing is assigning a TEXT IDENTIFIER NAME to a group of client id's.
I did a summary "distinct count" on the file number and I'm trying to get a TOP 10 summary. I get the TOP 10 client groupings with the correct counts, but I cannot get the report to show the OTHERS category. Does anyone know why the OTHERS Category is not showing. I am checking the box that says display OTHERS. ETC.
Thank you for your assistance.