Can someone help me With this:

[#1]

I need a formula for a growth rate by year in a combo Chart:

1. Dimension (years 2011-2016);
2. First measure - sum(sales)
3. Second measure - i need a growth rate comparing the previous year. Example  2012 grew 10% from 2011, 2013 grew 5% from 2012...

[Gysbert_Wassenaar]

Try sum(sales)/above(sum(sales))-1

[sunny_talwar]

May be this:

Sum(Sales)/Above(Sum(Sales)) - 1

[#4]

Thanks,

But The formula don´t work and returns "error in expression".

[sunny_talwar]

Do you have a sample you can share?

[#6]

Sorry, i´m new here. What kind of sample you want?

[#7]

if(year=2011),sum(sales),if(sum(sales)>above(sum(sales))),((sum(sales)-above(sum(sales)))/above(sum(sales)))*100,((above(sum(sales)-sum(sales)))/above(sum(sales)))*100

or

if(sum(sales)>above(sum(sales)),((sum(sales)-above(sum(sales)))/above(sum(sales)))*100,(above(sum(sales))-sum(sales))/above(sum(sales)))*100)