I have a report where I want to show #1 - total customers who have sales > 0 and also include the #2 -total number of customers who dont have sales. How can I get a total of customers (#2) without bring the field that I am doing the aggregation on? I dont want to bring the Customer Number (this is what is used to count customers) into the row of the report (leave it as a free characterstic).
Sales Customers who have sales Customers who dont have sales
10,000 1000 50000
Edited by: Patrick Nowak on Apr 2, 2009 7:12 PM