Headings that span multiple columns in a pivot table
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.
Re: Headings that span multiple columns in a pivot table
Thanks for your help Vineeth,
I have tried using the dimension: =ValueList('Jan A','Feb A','Mar A','Total YTD actuals','Jan B','Feb B','Mar B','Total YTD budget') and the expression as below. If I can get this to work I will then look into the variances using the same method.
However, it doesn't seem to work, can you see what I might be doing wrong?