Hello everyone,   I get the feeling that what I'm about to ask simply might not be possible.   I have a dataset with the columns Associate, ReportMonth, Month0, Month1, Month2, Month3, Month4 and Month5. In VA, my list table is designed so that ReportMonth variable is assigned to a drop down box which filters the table, a single ReportMonth value is required. Dummy data below: Associate ReportMonth Month0 Month1 Month2 Month3 Month4 Month5 Joe Bloggs Jul-18 1 2 3 4 5 0 Joe Bloggs Jun-18 2 3 4 5 0 7 Joe Bloggs May-18 3 4 5 0 7 1 Mary Sue Jul-18 0 14 12 31 6 1 Mary Sue Jun-18 14 12 31 6 1 21 Mary Sue May-18 12 31 6 1 21 3   Month0-Month5 all relate to the same metric and together gives a 6 month history from the given report month backwards. So, in July-18 Month0=July18, Month1=Jun18, Month2=May18, Month3=Apr18 etc. In Jun-18 Month0=Jun18, Month1=May18, Month2=Apr18, Month3=Mar18 etc.   My list table only allows one ReportMonth to be viewed at once, so this means that the Month0-5 columns all mean the same for everything in the list table, but of course when a different report month is selected, they would mean something else. I'm hoping to be able to overwrite the Month0-Month5, with the actual calendar months they refer to.   Anyone done anything similar? As I say, I fear it's a longshot!   ... View more