How to get Column total in SSRS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by vinaykumar » How to get Column total in SSRS

How to get Column total in SSRS

Rate Topic

Display Mode

Topic Options

Author

Message

sukruti.patel

Posted Tuesday, May 17, 2011 3:43 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 12, 2012 5:13 PM
Points: 9, Visits: 87

Hi

I am having hard time getting column total in ssrs report.

I have a report laid out as show below and I am having hard time achieving total.

Salesperson MarketSales BusinessSales AdSale Total
________________________________________________________________________________
Homer Simpson 50 20 30 100
Bart Simpson 200 -100 50 150

Note:
I have a multi-value parameter call Sales that has
list of sales Values example
MarketSales
BusinessSales
AdSale

User will select what Saless he wants to look and I have get the total of those columns value.

Any suggestions?
Thank you

Post #1110629

« Prev Topic | Next Topic »

Permissions