Hide the Dimention in a Pivot Table

[#1]

Good Morning All,

In a Pivot table, is it possible to hide the dimention( "Location Name"), I need to display only the Number of Invoices and Sales Expression.

Location Name	Number of Invoices	Sales
Test1	500	5211111
Test2	235	7855444
Test3	562	4785555

I would like to hide the Location Name.

Regards

Joe

[SunilChauhan]

see the attached file

hope this help

[#3]

Hi, If you want to hide a column, go to Presentation tab in the chart properties windows which can be opened by right clicking your pivot table and clicking the Properties, and select the column, and select the radio button Hide Column.

If you want to hide an expression from your pivot table, you can uncheck the Enable check box by selecting an unwanted expression from the Expressions tab in the chart properties windows which can be opened by right clicking your pivot table and clicking the Properties.

I hope this will help you to do that.

[Sokkorn · Accepted solution]

Hi Joe,

I think this one is not available yet in Pivot Tables. But we still can do it with these solution:

1. Use a text color Dimensions to make the text same color as backgound.

2. Macro:

     SUB HideDimension

        SET ch = ActiveDocument.GetSheetObject("CH01")

        ch.SetPixWidth 0, 0

     END SUB

Hope this help.

Regards,

Sokkorn

[vincent_ardiet]

Hi,

Instead of changing the color, you can, in the dimension properties, use the "advanced..." button and choose an "image" representation and check "Hide text when image is missing".

And of course, force the label of the dimension to a single space.

Regards,

Vincent

[#6]

Dear All,

Thanks a lot, your examples helped me lot...

Regards

Joe