Calculating the Total number per row

v2afrank

Hello,
I have two datasets. Customer and Devices. I want to create a simple report of the customer icluding the number of devices per customer. I tried the sum function but I didn't succeed. Can anyone help me.
To make clear what I want:
Customer Data
Customer Name
Customer address
Customer ID

Device Data
Device Name
Reference to Customer ID

The report should contain one row per customer containing these data

Customer Name Customer address Number of devices per customer

Thanks

Mikael P.

Create a new Total and use Count instead of Sum.