Dynamic Pivot column in BI Publisher

Summary

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

Content

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