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

  • February 23, 2018 at 4:34 am

    #1980907

    Thanks.  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.