Apples with Apples

[Anonymous]

Hi,

I have data in the below format.  What i would like to do, is compare 2012's data with the same months in 2011.

How can this be done?

This should allow , that when November's value is added, that the aggregated total will include the nov and then compare it to the same amount of months in the previous year.

Thanks in advance !

Regards,

[sunny_talwar]

May be like this

If(Sum(TOTAL <Month> {<Year = {$(=Max(Year))}>}Sales) > 0, Sum(Sales))

[Anonymous]

That gave me the total of both years

[sunny_talwar]

Really? Can you share a sample where it did that? That is so strange....

[philipp_ebner]

Hi,

do you want your Comparison  to be added as a new Expression? Or just a total

And do you want the object to be a Pivot table or a straight table ?