This content has been marked as final. Show 4 replies
I have a report that includes different columns of data. The columns have duplicate data. For each provider in column 1, I would like to get a distinct count of other columns (age groups ) based on the customer column. Below are some of the columns of the report.
|Provider||customer||age group 1||age group 2||age group 3|
The summary report should look like -
|Provider||distinct count(Age Group 1)||distinct count(Age group 2)||distinct count(Age Group 3)|
Any insight into this would be greatly appreciated.
Thanks in advance.