Hide Dimensions in Pivot table

[tyagishaila]

Hi All,

How can we hide dimensions in pivot table?

Thanks,

[tyagishaila]

Hi ramya,

Thanks for reply

Which code should I write?

Thanks,

[#3]

Hi tya,

Kindly downlaod that file and explore it and do r & d, you will know that where i written the code in dimension hiding.

Ramya.

[tyagishaila]

Thanks Ramya ,

its working

but as dimension hides, its Total also hide with it.

So I have to search another way to send charts into excel.

ThankYou

[#5]

Hello,

it's simple right just try that code with your own way u will get.

Ramya.

[#6]

It depends on which situation you want to hide your dimesion.

[jagan]

Hi,

The same works for Pivot table also just convert Straight table to Pivot table.

Regards,

Jagan.