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