Calculate total and percentage columns from ssrs 2008 r2 dataset for reports.
Posted on 2011-09-05
I have a situation to calculate the total of a column in dataset in ssrs 2008 r2 to calculate percentage in another column.
ValueColumn TotalColumn PercentageColumn
20 69 20/69*100
33 69 33/69*100
46 69 46/69*100
I want to create TotalColumn and Percentage from SSRS 2008 R2 dataset (using calculated field or some other method not sure!!!!!!!!!!!)
Your help and suggesionss are highly appreciated.