Pivot table horizontal dimension

[passionate]

Hi Geeks,

I am trying to create grid like structure in pivot table by having horizontal dimension as shown below:

But i want to remove this space which come when we have horizontal dimension.

Please find attached Application.

Thanks and Regards,

Pankaj

[ecolomer]

I think this is not possible.

Only you can change the color

[Anil_Babu_Samineni]

There is no way, But work around you could need Macro to get into work. Do you?

[passionate]

HI Anil,

Thanks for your response.

Can you share some macros for this.

Thanks and Regards,

Pankaj

[Anil_Babu_Samineni]

I got this information from mrkachhiaimp‌ May be wait for his reply