Page 1 of 1
Distinct count as total field
Posted: Mon Nov 12, 2001 2:51 pm
by Stephane_Plante_(Guest)
Hi,____I^m building a report on wich I need to have the number of invoices sent for each month and the number of distinct custumer to which I sent those invoices.____Is there a way to have theese results in R&R 8.1 (build 8.1.027)?____Thanks you very much for your fast answer!____Stephane Plante__splante@cia.ca
=> RE: Distinct count as total field
Posted: Mon Nov 12, 2001 4:36 pm
by kfleming
Sort/group your report by__Month__Customer__Invoice____Then create two total fields. Both will reset by month but the first will accumulate once per Customer and the second will be once per invoice. You get to accumulation by clicking the Options button in the totals dialog.________Kathleen__R&R Support