12 Replies Latest reply: Apr 21, 2017 11:51 AM by Vineeth Pujari RSS

    Headings that span multiple columns in a pivot table

    Chloe Connor

      Hi all,

       

      I've got a pivot table that has three month actuals and budget and also total and variance columns. These columns are all defined individually in the expressions as this allows me to add the variances.

       

      I currently have text boxes to span the actuals, budget and variance columns, but obviously any changes in the column widths requires manual changes to the boxes.

       

      I am therefore looking to include these headings in the table itself.

       

      Any ideas?

       

      Thanks!

       

       

       

      Each column is defined separately: