Hi guys,
I am struggling to create a calculation which looks at the year name in a report and calculates variances based on what year it is. If I had used a list, I think this would have been much easier but because of the data-setup I have been advised to stick to crosstabs. I have tried creating new data items but to no avail. Attached are what the report looks like in Report Studio - output reports are available if this would help
Any help would be much appreciated - as I dont post often here, Im not sure how much info to include so if any more is needed please let me know
Cheers,