OBIEE calculates Grant Total in a Pivot Table wrong when using selection steps and groups?

Question

Hi,

I have a Pivot Table in Answers that looks like this:

https://imgur.com/a/Q8XZlOq

Diesel and Gas are Members of a dimension.

D+G is just a group containing Diesel and Gas.

Now OBIEE does not calculate the sum on the right in some cases and in other cases, the sum is wrong.

I have tried already all aggregation functions on the Measure, to no avail.

Anybody know how this can be corrected? Is this a bug?

Thanks

maltedietsch · Answer

Oracle Business Intelligence Product Version 12.2.1.4.0 (Build BIPS-20180409020153 64-bit)

[Deleted User] · Answer

What exact version?