Merging Headers name in Pivot Table with variable date

[Anonymous]

Hi,

Appreciate if anyone can help me on this issue. I have a pivot table to that i need to merge column headers with variable dates. For instance, kindly refer to the image below.

As your info, the user able to select range of dates and it reflects to the column header i.e. 'Cumulative as at 31/12/2017' and 'Current Week (31/12/2017-7/01/2018)'. Is it possible to do merging columns with variables? I hope that you guys able to help me on this issue.

Thanks.

Regards

Vincent

[Anil_Babu_Samineni]

Not sure, I follwed you. Can you share application to test?

[Anonymous]

As per request, kindly find the attachment here. Thanks