differecne of this year value to the previous year

[#1]

Hi,

i m sharing the app where i need the differecne of this year value to the previous year

suggestion required

[ashfaq_haseeb]

Like this

Select any year from year listbox to get previous year sales.

Regards

ASHFAQ

[#3]

Hi,

Thanks for the reply

i need an extra column that represent the differences of the two years

Year	2012	2011	2010
values	400	200	300
Difference	400-200=200	200-300=100	- (no prev yr to compare)

this is the format how i req

[#4 · Accepted solution]

Hi

Please find attached file required solution.

Hope this will help.

If no years are fixed, we can do it in your mentioned format as wel.

[ashfaq_haseeb]

Like this

Regards

ASHFAQ

[jyothish8807]

Hi Wow,

Try this, hope it works.

if(year(Year)<>previous(year(Year)),Values - previous(Values),'') as Difference

order by Year desc

Regards

KC

[#7]

Thanks Rajeshri for replying

the expression you have given me yielded the result but what if i have added one dimension let it be item with Car, Bike, Bus added as a dimension to the chart then the chart looks weird and the expression not works

let me know