Forum Discussion

rchaturvedi27's avatar
rchaturvedi27
New Contributor II
5 months ago

Calculations on a Cube view dependent of column

Hi,  I would like to perform a financial calculation based on the current and previous quarter values, then returns the result. I have created the following layout of the cube view. ...
Cube View
TheJonG's avatar
TheJonG
Contributor III
5 months ago

Hi - I am not sure I am following 100% but you could try a dynamic calc stored in a UD8 member. The formula would determine the prior quarter based off the api.pov.time.name which would be whatever the time value is of each column. So it would work on any set of columns because the dynamic calc will execute for each cell and pickup the time period from that cell (which appears to be a different quarter).