I have the requirement to create a pivot table where the first dimension (project number) should have a custom header. It should contain the project number itself, the project description and the project status - here's a screenshot:
Furthermore, it should have a sum over all selected periods on the top (in this case since beginning of the project and YTD, as selected).
My current layout of the pivot table is this:
So, it is somehow possible to adapt the layout to match that of the first screenshot?
Or isn't that possible and do I have to write a an Excel export macro at all?
Sure, I've attached the qvw to my posting (reduced to the report in question and scrambled data).
Concerning the output my problem is that I have no idea how to make such sub headers with only the project number/description/status - the data below are the actual figures of that project grouped by chosen periods (e.g. "seit Projektbeginn" --> meaning all time, "aktuelles Jahr" --> meaning Year to Date).
Furthermore, I need to show sums of the chosen periods at the top (currently there is one sum over the selected period, if one is selected, or all data if no special period is selected).
The functionality already works, but I don't know how to transform it to the required layout.