How to count multiple entries in one column in SSRS?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » How to count multiple entries in one column...

How to count multiple entries in one column in SSRS?

Rate Topic

Display Mode

Topic Options

Author

Message

tscott 24349

Posted Friday, November 30, 2012 11:33 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 05, 2012 8:45 AM
Points: 1, Visits: 7

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.

Post #1391480

subbareddy542

Posted Tuesday, December 04, 2012 9:09 PM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 4:17 AM
Points: 832, Visits: 613

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

Post #1392774

« Prev Topic | Next Topic »

Permissions