How to sum the CountDistinct in the detail rows

• danyeungw

  Old Hand

  Points: 337

  More actions

  June 4, 2024 at 5:57 pm

  #4426201

  The SSRS report has a CountDistinct in the detail row grouping by Facility. It has a CountDistinct in the total row but it is not the sum of the detail counts.

  For example, the sum of CountDistinct in the detail row is 100 and in the Count Distinct in the total row is 98. I believe if the member went to 2 facilities, the detail rows count as 2 and the total row counts as 1.  How do I sum the CountDistinct in the detail rows?

  Thanks.

  

   

   

  • This topic was modified 5 months, 3 weeks ago by  danyeungw.
  • This topic was modified 5 months, 2 weeks ago by  danyeungw.
  • This topic was modified 5 months, 2 weeks ago by  danyeungw.
  • This topic was modified 5 months, 2 weeks ago by  danyeungw.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  June 5, 2024 at 6:10 pm

  #4426442

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.