Months Totals across page
Posted: Sat Apr 08, 2006 6:52 pm
I could use help to determine how to total the number of carriers used by mode by month across the page. ____Each shipment record includes a carrier name. Since there are many shipment records, there are many of the same carrier for each mode. I would like to count the unique carrier names for each mode by month across the page. I cannot find a way to do it using the totals function. I can total other data across months, but have not been able to total when there are multiple records of the same name.____My total band is mode. My total field is setup as follows:__1. Count Carrier name.__2. Reset on Mode__3. Accumulate on Carrier name__4. Preprocess the records__5. Condition = Month (1=January)____What am I doing wrong? Any help on this would greatly be appreciated.