How to counting group? 1

[bloomlight]

I have a report with groups....and need to count total grouped records at the end...how could I do that?

example:

Name ServiceDate ServiceType
John 03/02/13 B
John 03/11/13 A
John 04/01/13 B
Sandy 04/20/13 C
Sandy 05/20/13 C
John 06/10/13 F

the customer may use same "Servicetype" with different dates.....this particular report is to show how many different "serviceTypes" that each customer used.

Report:

Name ServiceType
John A
John B
John F
Sandy C

so the total is 4, not the 6.....how could I accomplish this?
Any help would be greatly appreciated!

 

[pmax9999]

Try this.

Create a formula (I've it called CountBy) that concatenates the Name and Service Type, as follows:

[Code {@CountBy}]
{Table.Name} + '/' + (Table.ServiceType}
[/Code]

Then create a Running Total:

[pre]
Field to Summarize: {@CountBy}
Type of Summary: Distinct Count
Evaluate: For Each Record
Rest: Never
[/Pre]


Hope this helps

Cheers
Pete

 

[xxyyzz49]

Are you trying to count just the distinct name and service type pairs? If so create a formula that concatenates the name and service type then create a summary that performs a distinct count of the formula and displays it for the groups.

// formula @NameType
{name} + ' ' + {ServiceType}

 

[bloomlight]

Thanks for both of you! I have used Pete's suggestion and it worked!