Calculating the Total number per row
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
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
Comments