Excel 2007 VBA - Customised Pivot : Column Heading and Sub Headings

[BiduraKumar]

Hi,
I have prepared a pivot through VBA, the usual codes which I was able to do after few research on this forum and internet.
The trouble is that the final pivot coming up is confusing though it contains the information that the user wants.
I have attached a sample report. Please see the sheet named Daily Summary which contains the report that was produced, it is confusing. The sheet named How I want contains the format that I want to produce for better user experience.
Please advise if the pivot I want can be produced through VBA, if so, please help me with the code or any other guidance is also appreciated.

My Regards

[BiduraKumar]

The file name is Customised Pivot - Samples.xlsx

[BiduraKumar]

Still waiting for some help I can use.