Total for Distinct Count column in Tablix or Matrix

• VRT

  SSCertifiable

  Points: 5776

  More actions

  December 3, 2015 at 7:16 pm

  #399421

  Hi,

  I have a tablix. I want the below way.

  Age Range customer count (Distinct) Purchased amt

  <20 10 1500

  20-30 120 8000

  30-40 60 4000

  >40 30 2000

  Total 220 15500

  But the total is not coming like that. Instead its taking 120. because in the data set I am getting have multiple rows with same customer repeating.

  How can I get the above result.

  Thank You

• pietlinden

  SSC Guru

  Points: 63509

  More actions

  December 10, 2015 at 11:24 pm

  #1845406

  Without sample data, this is hard to answer. Care to share? Or did you already figure it out?