Skip to Content
Former Member
Apr 02, 2009 at 05:12 PM

Total Count (aggregation) without showing Characteristic in Row


Gurus -

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