figueiredo.lucas779 Posted December 1, 2022 Share Posted December 1, 2022 My report exhibits the total rows existing in a group, like the example belowNAME | CLIENT_ID | PRODUCT |john | 100 | spoon |--------------------------------------------mary | 111 | dress |-------------------------------------------john | 100 | pan |-------------------------------------------Total Rows: 3How can i count only once the rows with the same id and display it in the report? example belowNAME | CLIENT_ID | PRODUCT |john | 100 | spoon |--------------------------------------------mary | 111 | dress |-------------------------------------------john | 100 | pan |-------------------------------------------Total Rows: 2 Link to comment Share on other sites More sharing options...
Solution jgust Posted December 1, 2022 Solution Share Posted December 1, 2022 Create a variable with a class type of integer and a "Distinct Count" calculation.In the expression add the field you would like a distinct count of.Finally, create a text field on the canvas to display the value of the expression. Link to comment Share on other sites More sharing options...
figueiredo.lucas779 Posted December 2, 2022 Author Share Posted December 2, 2022 Thank you jgust!! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now