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
Bookmarks