I have a simple table with turnover results by month;
Jan 320493
Feb 293118
Mar 322782
Apr 409382
May 349007
Now I want to make a new column which calculates the difference between the turnover of Mar with Feb for instance. So the third column will show that the turnover of March is ..% higher then the turnover of Feb. And this for every month.
I tried several things like Month-1 but I wasn't succesfull.
If by simple table you mean a chart with a "straight table" type, and if "turnover" is the name of the numeric column, you should be able to use =turnover/above(turnover)-1, and display as a percentage. If that doesn't work, or wasn't what you meant, I can get an example working in one way or another.
