take a look at the windowing functions in 2012
something along these line may help you get started
SELECT
Month
, Year
, TotalRevenue
, Company
, Descr
, SUM(totalrevenue) OVER (PARTITION BY company ORDER BY year , month) AS rt
FROM TotalRevenue_Investments;
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day