I have a ReportViewer with a Report having a matrix Table as follows:-
Months (Jan, Feb, .. Dec) as Row field
Fruits (Apple, Orange and Pear) as Column Field
Sales as Data/detail field
Data like this:-
Jan, Apple, 100
Now my output report looks like this
Month | Apple | Orange | Pear
Jan | 100|200|300
However, I want a total col on far right side like this
Month | Apple | Orange | Pear | Total
Jan | 100|200|300|600
How to do this ? I tried many times and search around can't find the solution. Pls... pls help. Thanks
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?