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)  Calculate Column Sum

Author  Topic  sn34 Starting Member 36 Posts Posted - 2010-10-13 : 10:07:30 Hello Example i have following tabele named Sales: ID------Number-----price 1---------5----------5 2---------6----------10 3---------18---------15 4---------35----------20 I whant to display this data in report service like that determine in wich interval([1-15] or [15-30] or [30-60] ) must be number's value and after that caclulate sum of this columns: calculate sum of column here 11----------------18-----------35 ID---------------Number---------------price-----------------[1-15]-----------[15-30]----[30-60] 1------------------5-------------------7----------------------5 2------------------6-------------------10---------------------6 3------------------18------------------15 --------------------------------------18 4------------------35------------------20---------------------------------------------------35 How can i do this?