I have a table called POLINE and it has these fields
I have been asked to write a query that will compute rolling sums of the counts and costs. They need this to look at today's date and then to compute these values for the next 26 weeks. So if today was April 6th, this would be the first column and then there would be 25 more columns ending on the 15th of September with each column being one week later than the previous column. The rows would be the item numbers. So I am grouping by item number but then how to I get the 26 rolling column totals?