There were few issues
1) Variable MaxMonth was not created (might have been missed in the sample)
2) MonthYear field was not read as date, but as text
3) some other minor changes
CURR_MONTH.qvw 209.8 K
Sunny - many thanks, it worked!!
Seems I was close to the solution, and looks like the difference mainly was the setup of the variable in the set analysis.
I researched the syntax on this site before and came across:
but you have corrected this to:
i.e. inclusion of the speech marks. What is the effect of the speech mark inclusion (aside from making it work!)