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:53 am

    #1980908

    Trawler - Friday, February 23, 2018 4:34 AM

    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.

    Okay, fine