Hi, I have a column with name ID. The ID value is repeated in query and I grouped it using group by.
It is showing correct way in report. At the end of the report I want the count of the ID. But it is showing total number of IDs in query and not the count displayed in the report. How to get the count displayed in the report.
Note: the second and third column have more than one row for single ID in report.