Grand Totals for percentages is calculating average but not sum This is due to the default property Automatic is selected for Grand Totals. Change this property t Sum to resolve the issue. Follow the steps below. Open the where the data grid is created. Goto Analysis -> Totals -> Total All Using -> Select Sum(or other function which you would like to use for all the measures. This should show all the measure Grand totals to Sum. Check the screenshot below: