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
I have a multi-value parameter call Sales that has
list of sales Values example
User will select what Saless he wants to look and I have get the total of those columns value.