replace and summarise from epm data source
Summary:
Remap and summarise many to one mappings when pulled from a all bottom members of account row?
Or - possible if I do put the remaps on a separate line?
Content (please ensure you mask any confidential information):
So account dimension pulls all bottom members of a dimension, purpose of the output being so someone can manually eyeball to a.n.other system and have assurance that the numbers in the two systems are the same. However, some of the members are remapped, one a many to one basis. I know I can use conditional formatting to substitute Dimension Name X to Y, but is there any way without separating out all of the remapped members from the all bottom level members selection to so they get summarised into a single line, again without pulling them out of the all