hi i have following type of data extracted from query col1 | col2 | col3 --------------------------- 100| A |30/12/2009 30 | B |30/12/2009 200 |A| 31/1/2010 50 |B| 31/1/2010 Now ssrs column chart shows data like :- one column for A = 100 & B = 30 on 30/12/2009 i want the chart to show like A = 100 And B = (A+B) = 130 on 30/12/2009 , similarly for 31/1/2010 data needs to be A = 200 , B = 200 + 50 = 250 . is there some trick to do this ? thanks in advance

try: SELECT col1 ,col2 ,col3 WHERE col1 - 'A' UNION ALL SELECT sum(col1) ,'B' as col2 ,col3 GROUP BY col3 my blog http://karlberan.wordpress.com/