Help with report building
Source: Migrated from Champions
Hey Everyone,
I am trying to create a report/cubeview for our regions. But how do I get the dynamic calculation inserted into my CV? (Highlighted Yellow) Do I ne...
Forum Discussion
The way I did it-
Create another Account hierarchy for all the calculated accounts you want, in this case Rerent profit margin% etc
on each of these accounts, you can set the formula you want it to calculate. Use these in the cubeview member filters.
Ofcourse, like Andy mentioned, the formula would again call the GetDataCell function within it.
And if it is a cubeview and you don't want to create the hierarchy members, you can always use the Member filter and give your formula to getdatacell in the cubeview.