Hi,
I'm trying to figure out a way to allocate constant values (revenue) throughout the lower levels of a hierarchy (i.e levels that have no relationship with revenue), while at the two highest levels of the hierarchy I would like revenue to act as a normal roll-up measure. The powerplay transformer manual tells me not to use the allocation option for this, but it forgets to mention what I need to do instead. I can always opt for an "external rollup" where I provide the revenue figures for each node separately, but I'm posting the question here to see if there are alternative, more efficient, solutions.
Thanks in advance.
Rob