It will be better if you can explain with a sample workbook using superstore data as we are usually lost from Top to Bottom in a long description without workbook
1 of 1 people found this helpful
try aggregating the values ((sum([Count Latest])/sum([Count 3 Years Prior]))^(1/3)) - 1
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.
So simple... Thanks a million Jim!
Glad to help out
I looked at the formula - that is a CAGR calc - are you aware that you have 4 data values over the 3 year interval ( I assumed you meant to do that)
Thanks again. Yes I have a count 2016, count 2017, count 2018, count 2019. This would be the CAGR from 2016-2019.