Question
TCS
US
Last activity: 11 Apr 2023 15:56 EDT
Report Definition - Getting total count of each Distinct value in a column
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
Accepted Solution
Updated: 11 Apr 2023 15:56 EDT
Coforge
IN
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.
NCS Pte. Ltd
SG
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.
TCS
US
@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
Accepted Solution
Updated: 11 Apr 2023 15:56 EDT
Coforge
IN
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.
NCS Pte. Ltd
SG
Hi @John Joseph: Please find sample here.
You can use the same column to perform count too as below.
Please let us know if you are facing any issues.
Thanks.