Dynamic Pivot column in BI Publisher
SummaryNeed 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.