Hi,
I have the followings in a table:
FAC_NAME 2006 2007 2008
MAL 300 200 600
GES 200 500 400
Pls. note the Years are dynamic, meaning it can start from 2005 or 2006 and can go up to 2011 or 2013 etc.
So, what I want to do here is to insert a new column and calculate the percentage for year over year to see if the revenue has increased or decreased. In this example, I would like to see the following results:
FAC_NAME 2006 2007 2008 2007 - 2006 % 2008 - 2007 %
MAL 300 200 600 -33% 200%
GES 200 500 400 150% -20%
Here is the formula I used to calculate the percentage for (2007 2006 %) is (2007 2006)/2006. See attached sample file. Pls. feel free to change the structure; i just want the best way to achieve the final result. Thanks
I have the followings in a table:
FAC_NAME 2006 2007 2008
MAL 300 200 600
GES 200 500 400
Pls. note the Years are dynamic, meaning it can start from 2005 or 2006 and can go up to 2011 or 2013 etc.
So, what I want to do here is to insert a new column and calculate the percentage for year over year to see if the revenue has increased or decreased. In this example, I would like to see the following results:
FAC_NAME 2006 2007 2008 2007 - 2006 % 2008 - 2007 %
MAL 300 200 600 -33% 200%
GES 200 500 400 150% -20%
Here is the formula I used to calculate the percentage for (2007 2006 %) is (2007 2006)/2006. See attached sample file. Pls. feel free to change the structure; i just want the best way to achieve the final result. Thanks