Comparing years with Aggregate

[#1]

Hi QV Community,

I have a need to compare this years figures to last year's figures. It seems that where aggregate is not involved, this works okay. I have two expressions where Aggregate is involved and I can't seem to get the expressions right.

The expressions are:

and

I have attached a sample copy of the document for more clarity.

Thanks,

S

[#2]

Hi

I took a look at your application and I do not check why you need to aggregate in your expressions at all (in both charts). You do not have any dim in your charts and for the moment it seems to be correct when you not use the aggr()-function. But similar in both charts. If you want to sum along the edge of "SMD_Reference" it should be correct in both charts, or incorrect in both.

Regards, Roland

[#3]

The thing is that I'm trying to match my figures up to an existing report system. I only get the correct figures when I aggregate. Is there a way to keep the aggregate in the expression and reference last year's figures?