Hi,

I'm creating a pivot table with Analysis Server. My column values is displayed as average, but I want the grand total to be the sum of all the averages of that column. The grand total should be displayed as a row under the table.

I've been browsing for a long time now, but I cannot find a solution for this.

fyi- I cannot change anything on the data model.

Thanks, Whinney