Creating a pivot table on RTF Template with dynamic sheets

_vero_

Hello Team,

I am trying to create a pivot table with the following fields: Source, Year, Month, Measure. I would like to generate the output in an excel format to visualize the year as separate sheets, maintaining the pivot format with source on the rows and the year in months on the columns. However, once the pivot table has been generated, even using a recurring group, the output generates the same table on two different sheets without separating the data by year. Is there a way to generate such a table?

Thanks

Mallikarjuna Kuppauru-Oracle

Hi @_vero_

Thanks for using Oracle Communities.

Can you refer below MOS doc -

EBS (BI Publisher) R12 : How To Design An Excel Template With Multiple Sheets And Pivot Table Features (Doc ID 2344530.1)

Regards,

Arjun