I am trying to create a Rolling Month report for the past 3 months.
I have 3 tables
RAGvalues
TeamValues
Dates
These are used to create a table with the data that I require
TeamNumber | RAGMonth | RAGYear | RAG | RollingMonth | DisplayDate
Team1 | 1 | 2018 | R | 13 | Jan-2018
Team2 | 2 | 2018...