4 Replies Latest reply: Jul 29, 2016 10:38 AM by Stefan Jaindl RSS

    Custom subheaders in Pivot Table



      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?