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  Median Calculation in Matrix Report

Author  Topic  pmak Starting Member 41 Posts Posted - 2006-12-21 : 00:58:10 I have a Matrix Report with the dataset based on an OLAP cube. On of the dimension consists of two date time fields and an aggregate field "duration" derived using "Datediff" function between the two date time fields on the data source view when creating the OLAP cube. I want to create a "Measure" to calculate the "Median" value of the field "Duration". The Matrix Report has three levels of row groupings and single level of column grouping. I want to assign the Median value of the duration side by side of another "Measure" field on the report. The Median duration will be re-calculate based on the Row/Column grouping. How to do this? First of all how to create the Measure of the Median Duration? Then how to make it dynamically calculate based on the Row/Column grouping? Thanks and Merry XMas. Paul Mak