How to compute sales growth rate

[#1]

Hi All

I need to compute the sales growth rate for last 10 year sales data .

So far i am able to compute sales growth for CY vs PY .

This approach can only sales 1 growth rate.

what i need is the Table , which column 1 is Year and column 2 is sales on that year and column 3 i want to display the growth rate.

year............sales..............growth rate

2000............100...............

2001............110...............10%

2002............110................0%

May i know what is the expression for growth rate ?

[#2]

Hi there,

You can always use Peek function to figure out growth in script level, and above function in Chart level.

Regards,

[Jason_Michaelides · Accepted solution]

Try:

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

Hope this helps,

Jason

[#4]

Hi All

Thank you very much , it work . can some one show me how to use peek ?

[#5]

check this excellent example,

Peek() vs Previous() – When to Use Each

[#6]

Hi Sir

Thank you for your link

Paul