Did you try table calculation?
2 of 2 people found this helpful
Hi this can be done with a table calculation percent difference the formula is:
(ZN(SUM([Visits])) - LOOKUP(ZN(SUM([Visits])))) / ABS(LOOKUP(ZN(SUM([Visits]))))
for you it is important to start the calculation in 2006 see below
it will return this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
I didn't know about the "Relative to" function! Thanks so much for your help!!
Glad to help out