year on year % growth

[#1]

Hi,

I have a pivot table, where i want show account wise the  year on year % growth i.e. i want to show  year on year % growth using this formula

(Cur Year- Prev Yr) /(prev Yr)). But the value gets converted as -100% if i use year in my dimension . Is it anyway possible to show in the below format in qlikview:

Account Type	year	% year on growth
C	2012	50%
A	2012	80%
B	2011	60%
C	2011	50%
A	2010	65%
B	2010	70%

Please find the attached files.

Looking for your response at the earliest

[er_mohit]

see the attached file

[#3]

Hi

use this expression

((sum(amount)- Before(sum(amount)))/Before(sum(amount)))

[#4]

Hi Mohit,

Thanks for your reply, i do not have current year & previous year separately, I am calculating current year & previous year using financial year (By  Set Analysis). Can you help me in this

...

[#5]

Hi,

This solution does not work as I am using set analysis for calculating current & previous year

Regards,

B.Vijayalakshmi