How to Hide Header Line in Pivot table?

[#1]

Hi,

    I am using Pivot table with 1 dimension and 1 expression. I want to hide all the value of dimension header but I want expression value as per dimension wise.

Example

Month |   Jan      |    Feb      | Mar

%Var  |   10.0%  |   12.0%   | 10.0%

So here I want to hide month dimension and I want %var as it is.

Help me out.

Thanks

Ravi Balar.

[jsingh71]

Hello Ravi,

I think you already know how to change the dimension name in chart. If you dont want to display the name then under Label Text Box enter blank(Press space bar once) and it will hide the dimension name in your chart.

--Jai

[Anonymous]

PFA,

HOPE this is the thing you require.................

Regards

NITIN

[#4]

Hi JSingh,

    That will hide only my dimension label I want to hide entire dimension but its effect should be there.

[#5]

Dear Ravi,

It is not possible with Pivot Table but In straight table you can hide column(Dimension).

The only you can do is just go to dimension label and press a space bar.

Thanks & Regards

Prince Anand

[#6]

Yes I got it but in straight table after hiding dimension it effect is disappeared So.

I want other data depend on that dimension but dimension should be hided.

[#7]

Dear Ravi,

But in Pivot Table there is no any inbuilt functionality to hide dimension.

Thanks & Regards

Prince Anand

[#8]

In this ,

How you have hide that file_name and its values?

[PrashantSangle]

Hi,

Can attached sample apps?

When you hide dimension in straight table its effect remain.

Check it again.

Regards,

[jsingh71]

Do one thing add one text object on top of your dimension name. It will hide your dimension and effect remain as well.