How to get Column total in SSRS

• sukruti.patel

  SSC-Addicted

  Points: 483

  More actions

  May 17, 2011 at 3:43 pm

  #236338

  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 2030 100

  Bart Simpson 200-10050150

  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