Question related to agg/spread method.
Hi,
We have a measure which is in item_svdc [warehouse] level. I wanted to convert it to item_str. svdc and str are in different hierarchies. I tried to use repl spread method to convert the values. What happened here is when an item is connected with multiple svdc, when i convert it to str level, the values at all svdc is summed up and its shown as a single value. Please let know if we could try some other spreading method to resolve this issue so that the item value is replicated to store level without any adding of values.