I have a table that includes a field called ABC_Rank. this field returns the values of A, B, C, or N. these are how we have our companies customer rankings setup. i need to know how to get a total for each. this report is by sales rep so i will need an individualized total for each rep as well as an ending report total for all reps w/ a,b,c,n ranking
In other words the result from what i have pasted below would be:
A - 1
B - 2
C - 1
N - 5
OffDayDeliveriesLocationTypeCustomer_NameRouteSequence_NumPtyDelivery_DaysTotal_PiecesCubeWeightTotal_CostService_TimeOpen_CloseSales_NumSales_NameABC_Rank0000058035SITFRESHENS LAREDO MALL291S30W26327289200:20:107:00 / 18:00
* * * * *N0000059809SITEL VAQUERO MEXICAN REST102S65
16134732400:00:000:00 / 0:00
* * * * *N0000138809SITCITY OF CORPUS SENIOR SRV330N180TR20188902500:16:537:00 / 18:00153ROCKY MYERSA0000103861SITCHINA INN(H)301S60T9132742700:10:5410:00 / 21:00153ROCKY MYERSC0000043577SITHEADSTART DOWLING301S95M28215071100:00:000:00 / 0:00153ROCKY MYERSB0000025083SITSCORES431S90MF23185542600:18:327:00 / 18:00153ROCKY MYERSB0000058391SITPIRATES ISLAND SEAFOOD HOUSE535S130MR33278595300:18:228:00 / 14:00153ROCKY MYERSN0000058391SITPIRATES ISLAND SEAFOOD HOUSE630S270MR211532910000:13:528:00 / 14:00153ROCKY MYERSN0000058391SITPIRATES ISLAND SEAFOOD HOUSE233S170MR95882,56110100:41:378:00 / 14:00153ROCKY MYERSN