I know there's a way but I'm drawing a blank on best approach and method. I have one rolling year of data so say July 2019 to June 2020. However, on the report I'm only showing year to date so January to June. What I'd like to be able to do is from July to December provide a projection based on past July to December and current January to June. This would be in a table not a chart. I'm really just needing to know the best formulas or methodologies to use so I can google it or start working through a solution.