I have a report which list the billing documents which sort and group by sales office. The layout is something like this
Sales Office Billing Document Amount
A 0001 1000
A 0002 1000
Doc. count = 2
B 0003 1500
Doc. count = 1
I know that I can add a column with the value 1 in each cell and sum them up.
Is that any other alternatives?