Home Forums Reporting Services Reporting Services 2008 Development How can i use the column in select statement which is there in pivot RE: How can i use the column in select statement which is there in pivot
gbritton1
SSCertifiable
Points: 6522
More actions
April 8, 2014 at 3:25 pm
#1704324
YOu can't do the sum in a pivot by itself. However, you could do pre-aggregation in a CTE or subquery then pivot the results. That might just do it for you