Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I would like the third column to display to display the value of the previous month however, the previous function is not picking up in the directory of functions as shown below. Is there any other way to get the value of the previous month?
Thanks in advance.
Regards
Daanyaal
Previous() is a Script function, not a chart-function.
Try the Above() function. In pivot tables you can use the before()-function
Please like and mark my answer as a solution, if it resolved your issue.
Previous() is a Script function, not a chart-function.
Try the Above() function. In pivot tables you can use the before()-function
Please like and mark my answer as a solution, if it resolved your issue.
It worked,
Much Appreciated