I am having trouble creating a running aggregate product. I have a data set with projections quarterly and different categories. Every formula tried either gets a circular reference error or an error with mixing values and aggregate values. I have attached a sample data set. The goal is to calculate the compounded return in column E. See below of a screenshot of the data:
Any help would be greatly appreciated! Thanks!