Diffrence Beetween Year

[sona_sa]

Hi I have 2 years Data, Suppose I want to do the analysis on 2 Years comparison then Please calculate a expression between Current Year amount - Previous year amt and Difference between these two year in dot.

Please find the attached qv.document for the same.

Thanks.

[sona_sa]

Answer will be 245.84.

[ecolomer]

here you are attached QV file

[sona_sa]

Thanks for relpy,

Y not the value (245.84) is displaying in  LINE BAR GRAPH.

I want that difference in  SQL.

Thanks///

[jagan]

Hi,

Please find attached file for solution.

Regards,

Jagan.

[sona_sa]

Thanks for reply.

But I required a dimension like cylclic Group (Year / Qtr / Month & Week).

This is without dimension.

Thanks.

[jagan]

Hi,

It is not possible.

Regards,

Jagan.