6 Replies Latest reply: Apr 6, 2016 6:33 AM by Rui Guerreiro

# Can someone help me With this:

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...
• ###### Re: Can someone help me With this:

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

• ###### Re: Can someone help me With this:

May be this:

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

• ###### Re: Can someone help me With this:

Thanks,

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

• ###### Re: Can someone help me With this:

Do you have a sample you can share?

• ###### Re: Can someone help me With this:

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

• ###### Re: Can someone help me With this:

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)