How to count multiple entries in one column in SSRS?

• tscott 24349

  SSC Rookie

  Points: 49

  More actions

  November 30, 2012 at 11:33 am

  #285706

  If I have 1 column displaying current product of 200 accounts. How can I see product counts? So if they're 4 products used by these 200 accounts. How can I get a count of each. So for example:

  Prod1 = 60

  Prod2 = 40

  Prod3 = 75

  Prod4 = 25

  And then have this displayed at the bottom of the column?

  I'd like to avoid hardcoding the product names, because I have other columns where I'd like to do the same thing, but I have 5-10 different entries.

• subbu1

  Hall of Fame

  Points: 3281

  More actions

  December 4, 2012 at 9:09 pm

  #1565557

  In that report take one more table item After you will do grouping on product next comun use count funcation............