Formula Summary type on LOOKUP or OFFSET
We are a NZ Telecommunications company. We have the need to report metrics such as ARPU $ (avg revenue per user) and Avg cost per user across our segments. I can do this compared to our forecasts & budgets easily but if I try to do this for Prior Year or prior period data I am stuck for a solution.
I cant use formula type summation with either a LOOKUP or OFFSET which is needed to look up the prior
period comparison. I have a segment hierarchy and I need it to calculate the ARPU at each level of the list not aggregate so I need the formula to be used. I have struggled for years on this one but Prior year and prior period reporting has just jumped up in importance
Would appreciate if there was any solution out there or if this could be put forward "Request for Enhancement" to enable these important metrics to be properly calculated.