Jump to content

Recommended Posts

Posted

My report exhibits the total rows existing in a group, like the example below

NAME | CLIENT_ID | PRODUCT |
john     |        100        |   spoon         |
--------------------------------------------
mary    |        111        |    dress         |
-------------------------------------------
john     |        100        |   pan            |
-------------------------------------------
Total Rows: 3

How can i count only once the rows with the same id and display it in the report? example below

NAME | CLIENT_ID | PRODUCT |
john     |        100        |   spoon         |
--------------------------------------------
mary    |        111        |    dress         |
-------------------------------------------
john     |        100        |   pan            |
-------------------------------------------
Total Rows: 2
 

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

  • Solution
Posted

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.

 

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...