Subtotal on Group by

Question

Hi friends,

Im in OBIEE 11.1.1.7. I have a report with the following columns like below

If u can see @ the above 419 is my employee no which has two records for one of the column as 26116.93 and 0.00 for self and child. i want to display another column seperately with a sum of total of 26116.93+0.00. As i need this another column that calculates the sum of(26116.93+0.00) according to the employee number wise(group by).

Is it possible to achieve this scenario.

Thanks in advance.

Regards,

Saro

Saro · Answer

Dear Cesar,

Thanks for the reply again.

I do noticed that my employee number column is in varchar type and due to that it resulted in incorrect numbers it seems. After that i changed the formula to below to number format and it worked like expected.

sum ("Airfare Adjustment-fact"."Result Value" by EVALUATE('to_number(%1)' AS INT, "Airfare Adjustment-dim"."Employee Number"))

Thanks for your timely help:-)

Regards,

Saro

cesar.advincula.o · Answer

If the problem persist, please, could you put an image of your star schema RPD, in the "Business Model and Mapping Layer".

Kind Regards,

cesar.advincula.o · Answer

Hello Saro,

This will be enough for your requirments, please, in the agreggation rule (Totals Row) ensure the combo box with "sum" option is selected.

This give the sum by

And ensure this, in blank