I have a Straight Table that shows sales values broken down by period for the current financial year and the previous one, and showing accumulated year to date values.
I have now got a % comparison between each period to show the increase/decrease for that period between last year and this year, but what I can't work out is how to show a % comparison in the same way but based on year to date values instead of individual periods.
Is anyone able to suggest the correct expression to use for this please?
An example QVW file is attached to show the sort of thing I mean (can't attach my real one due to the fact that it has confidential data in it).
Any help on this would be much appreciated.
Many thanks.
Andrew