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