Hi, I have a requirement where there is a Measure1 from Dataset A and Measure1 from Dataset B. Dataset B is a part of Dataset A. I need to create a formula where it says DatasetB(Measure1) / DatasetA(Measure1). This looks like a simple division like A/B but it is not yielding the expected results. I have already tried to link datasets and also merge them.
Any help would be greatly appreciated. Thanks.
I don't see where this is possible in this tool.
Something like this could be accomplished with Analysis Office formulas if you are on 2.4/2.5 and your datasources are BW or HANA
I figured it out using Link Dataset. I got the desired result. Thanks!