Noodlestall
New member
- Local time
- Today, 13:00
- Joined
- Mar 5, 2018
- Messages
- 5
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 | G | 14 | Feb-2018
Team3 | 3 | 2018 | G | 15 | Mar-2018
I can get the crosstab table to display with the columns with the DisplayDate however they end up in alphabetical order Feb, Jan, Mar.
I need to order them based on the rolling month ascending, however I don't want the RollingMonth displayed. Is there a way to order the columns by Rolling Month but display the DisplayDate?
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 | G | 14 | Feb-2018
Team3 | 3 | 2018 | G | 15 | Mar-2018
I can get the crosstab table to display with the columns with the DisplayDate however they end up in alphabetical order Feb, Jan, Mar.
I need to order them based on the rolling month ascending, however I don't want the RollingMonth displayed. Is there a way to order the columns by Rolling Month but display the DisplayDate?
Last edited: