Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Moving Annual Total cross tab by month with Difference in one column RE: Moving Annual Total cross tab by month with Difference in one column
subramaniam.chandrasekar
SSCarpal Tunnel
Points: 4223
More actions
February 23, 2018 at 4:53 am
#1980908
Trawler - Friday, February 23, 2018 4:34 AMThanks. I managed to solve this linking to a time table and using Lag Over (partition AccountNo, [Timetable].Month Order by [Year]. The data was then returned to SSRS and grouped appropriately.
Okay, fine