Dynamic KPI change in %

[Elliot2]

Hi

I´m seeking a dynamic formula to visualize the change over time in %. Right now I have the KPI manually written by taking the (new value - old value) / old value. I want the KPI to be dynamic. If I sort by for example, year, I want the KPI to change to the change in % for that year. How would a formula for that be?

Thanks, Elliot! 

[Chanty4u]

May be this ?.

(Sum({<Year = {$(=Max(Year))}>} Sales) - Sum({<Year = {$(=Max(Year)-1)}>} Sales)) / Sum({<Year = {$(=Max(Year)-1)}>} Sales)