Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Try:
(Sum(Sales)-Above(Sum(Sales)))/Above(Sum(Sales))
Hope this helps,
Jason
Hi there,
You can always use Peek function to figure out growth in script level, and above function in Chart level.
Regards,
Try:
(Sum(Sales)-Above(Sum(Sales)))/Above(Sum(Sales))
Hope this helps,
Jason
Hi All
Thank you very much , it work . can some one show me how to use peek ?
check this excellent example,
Hi Sir
Thank you for your link
Paul