Please help with the last year values

[#1]

Hello everyone,

Please help into this, i have one single table, i am getting Last Year values from the same table by using key ( i created the key based on the year and other objects)

Can you please look into the image for the issue.

If you look the value for the 2011 the last year value (2010) is coming properly, but if see 2012 value, the last year value (2011) is not coming properly,

Can any body tell what is the issue.

Thanks in advance

[PrashantSangle]

Hi,

I will suggest you to do you calculation on front end.

Use Set analysis as Enrique Suggested.

Regards

[#3]

Hello Enrique,

Why two year fields here?

Thanks

[PrashantSangle]

Hi,

He had given you general Syntax as

Write expression

For Current Year

Sum({<YearField={"$(=Max(YearField))"}>}Sales)

and

For Previous Year

Sum({<YearField={"$(=Max(YearField-1))"}>}Sales)

and Remove Other Field as per Requirement which Enrique try to suggest you.

Regards,