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  Development Tools  Reporting Services Development  sum of column in matrix

Author  Topic  miclare Starting Member 5 Posts Posted - 2006-06-24 : 00:12:15 hi reporters! i m using matrix in my project and i want to calculate the (cell_value/sum_of_column). for data cell values we have to use sum or another aggregate function for subtotaling, so for the cell value i m wirting sum(column) / A. how to write A that points to sum of all cells on the column. x_column y_column z_column sum(y_column)/A A?