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

Dynamic Pivot column in BI Publisher

Received Response
edited Jul 3, 2020 9:42AM in Reporting and Analytics for ERP 1 comment


Need the column of a pivot table to be dynamic in BI Publisher


We have a requirement to display GL balances by BU hierachy and period.

As the users can run the reports for multiple periods and the period balance has to be in columns, we have used pivot(Jan-20, Feb-20 format below. Data model would only give them in rows.).

The next requirement is to display BU hierarchy which is fine. But they want to have it dynamic. When they choose only display level 2,4,9 then the pivot should be of following format.

BU level2 Level4 Level9 BU

Howdy, Stranger!

Log In

To view full details, sign in.


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