Forum Discussion

Sergey's avatar
Sergey
Contributor III
3 years ago

Implementating a CAGR calculation in cube view

Dear community, I am trying to implement a CAGR calculation as shown in this link : https://blog.hubspot.com/marketing/cagr-formula-excel I have 3 years of data in a cube view, hence my calc shou...
Cube View
Sergey's avatar
Sergey
Contributor III
3 years ago

Hi Chris,

I understand the logic, but this indicator will be applied to several indicators, scenario & years, so I don't clearly see how we can use a dynamicCalc member in this situation.

If I use a business rule in a cube view, is there a way to reference previous columns of a given cube view ?

Regards,

Cyril