I have loaded in a table with Fiscal Year and RowNo() in order to be able to call the Fiscal Year value in set analysis through the max RowNo. I have done this because I was unable to call the maximum Fiscal Year (format - 'FY14').
My formula should sum Volume for the most recent FY in the model (i.e. max row number). My set analysis is currently not working:
glad to help, sorry I thought you had those disconnected which is what I went with in my example.
One thing I would say is, you might want to avoid hardcoding the expressions like that, as it means next year you will need to adjust for the latest year, better to use a variable so it dynamically changes as time goes on