I've been dealing with this problem for a while and I'd like you to take a look:
My data set contains Actuals and Budget figures in the same table, separated by a field named TipoMov. Since budget is for the full next year, when I add the next year budget and do a normal set analysis for actuals, last year figures are the same as this year figures:
Since this is classified info I cannot share a quick sample, but i can create a small app with the problem in it so you can take a look at it, only problem is I would be able to do it until wednesday, how can I get back to you when it is done?
Attached you can find an app with my issue. Something I couldn't realize with my full app (due to the lenght of the data and the complexity of my formulas) is that the formula is indeed working but the "Date" dimension is preventing data to be displayed.
A workaround I thought of was to add month/day dimensions, remove date dimension and add set expressions to budget and actuall figures, however that would only work for the latest year...
My last resort is to load budget only to the latest actual sales date, but if anyone ever wants to see future butget regardless of not having sales to compare to, I'd have to add it and -again- last year figures might not work.