Hi all, I'm new working with SSRS. I have a doubt, it is possible to create a Filtered Calculated Field. For example: I have a dimension Product (contains: Car, Computer, TV...) and a measure Revenues. But i want to create a measure Car Revenues and other measure Computer Revenues. And Car Revenues represents only the Revenus from Car and Computer Revenues Represent only the Revenues from computer. Is this possible? Thanks in advance. Jorge OS

Hi you need something like: SELECT product,SUM(revenues) FROM Orders GROUP BY product Robwww.crmconsult.info Twitter:robertpeledie

Hi Jorge, Besides what Robert gave the T-SQL in the database, you could also utilize the matrix control in the reporting service, matrix could display grouped data and summary information. You can group data by multiple fields or expressions in row and column groups, which provides functionality similar to crosstabs and pivot tables. At run time, as the report data and data regions are combined, a matrix grows horizontally and vertically on the page. Values in matrix cells display aggregate values scoped to the intersection of the row and column groups to which the cell belongs. For more information about utilizing the matrix, please click this link http://msdn.microsoft.com/en-us/library/ms157334.aspx Thanks, Challen Fu