Oracle Transactional Business Intelligence

Pivot table in rtf bi publisher 12c
Summary
Edit for-each to fetch on another for-each-group
Content
Hello developers,
In pivot table, it fetch all empcode <?for-each:$c2629//R1?> with respective to the cross table but in my case i want to fetch empcode only that belong to the above for-each-group (dept,company,period).
can i edit code in the for-each of empcode to fetch based on the above for-each-group ?
Thanks in advance.
Version
bi publisher 12C
Comments
-
i want to group emp code (green G) instead of group (red G)