I have a pivot table which looks somewhat like this:
(illustration from excel)
I want 'YTD' and '10/30/2017' to be merged for capital and expense hours.
I cannot put a label on top of the expressions because it is a pivot table so the size of the table is not fixed. Also I add (with a load * inline) new dimension and then drag it over the expressions horizontally because YTD and Last Week (10/30/2017 in this example) are 4 different expressions. So if I drag YTD over the expression, it will appear over both the yearly and weekly expressions.
Is there any way to achieve what I have shown in this snapshot above?
Thanks,
YASH