Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am a newbie and this is my first post. I need to show the growth percentage quarter over quarter and am stuck. Do you have any suggestions of how I would do this? I tried Column-Column/Column ect.. not working. I have attached a screen print.
I think this is what you are after:
formula =((y-x)/x)*100
x = previous quarter
y = next quarter
The above() function will grab the value from the preceding row. It may help you
ex:
( Sum(Sales) - above(Sum(Sales),1) ) / above(Sum(Sales),1)