Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  % of total in matrix

Author  Topic  Roman_K Starting Member 1 Post Posted - 2010-03-08 : 23:13:44 Hello, Say, I v got matrix with Users as Rows and Category as Columns, and there is [# of items] in each intersection. I v got Total Column where all [# of items] are summarized. I want to add [% of items] in addition to [# of items]. [% of items] for certain Category = [# of items] of this Category / Total. Any Ideas? T h a n k s ! imposible just takes more time...