You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

for-each OTBI

edited May 29, 2024 11:53AM in Reporting and Analytics for HCM 3 comments

Hello everyone, I have the following problem:
I have a report that is grouped by several groups and subgroups. I need to be able to total the columns for each subgroup and group at levels 1 and 2.

In the rtf template I have the following structure:

I want that in each column, the TOTAL_SUBGRUPO2 field be the total of the entire column of that subgroup. Let the TOTAL_SUBGRUPO1 field be the sum of the values ​​obtained in TOTAL_SUBGRUPO2. and the column TOTAL_GRUPO the sum of the values ​​of all the TOTAL_SUBGRUPO1. Taking into account that there may be many TOTAL_SUBGRUPO1 and TOTAL_SUBGRUPO2 for each GROUP.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!