Report Definition - Getting total count of each Distinct value in a column

General
,
1

Hello

Can anyone help me on the below requirement. I have a table with below data.

S.No Name
1 ABC
2 ABC
3 XYZ
4 XYZ
5 XYZ

I want to get the total count of distinct values i.e., ABC = 2 and XYZ= 3. Is it possible in Report definition?

Thanks

2

Hi @John Joseph: Yes it is possible. You can add 2 columns in the report (Name, S.No) and add summarize option as count for S.No column.

Thanks.

3

@ArulDevan . Thanks for your reply

S.No Name

1 ABC

2 ABC

3 XYZ

4 XYZ

5 XYZ

For the above example, S.No will be 5; whereas the requirement is, I need result as ABC = 2 and XYZ = 3

4

@John Joseph

Add Name twice as 2 column to your RD. Summarize one as count.

Result of report will give you counts of each Name values Infront of them, similar to what you are looking for.

Add Name twice as 2 column.png
Add Name twice as 2 column.png1181×200 15.1 KB

5

Hi @John Joseph: Please find sample here.

sample1.png
sample1.png996×130 10.1 KB

You can use the same column to perform count too as below.

sample2.png
sample2.png992×125 10.2 KB

Please let us know if you are facing any issues.

Thanks.