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

    Custom subheaders in Pivot Table

    Stefan Jaindl

      Hi,

       

      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?