Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to get Column total in SSRS Expand / Collapse
Author
Message
Posted Tuesday, May 17, 2011 3:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 09, 2014 12:41 PM
Points: 9, Visits: 92
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 »

Add to briefcase

Permissions Expand / Collapse