I have a problem in a Webi report.
My report is based on two sources, one Bex query and one universe. There s a common object, which i have used for merging, and it works good.
However when i want to display total of measures from Bex source, based on dimension from universe, it fails to do so.
As you can see in the screenshot attached, sum value shows total of whole report, instead it should show total of each group.
Does anyone know, is it an expected behaviour? Or how to fix it?
I already tried Sum in break, sum in section, foreach and in functions, did not help.