12 Months Rolling table in SSRS

[HolidayHero]

Hey, A rolling 12 month table can be created by incorporating a date field into your where clause of the query that generates the table.... such as:

where date >= DATEADD(m, -12, current_timestamp)

Very simple yet effective.