Hide column in Pivot table

[Anonymous]

Hi All,

I have the below Pivot table where I have generated dates which isn't available in my DB. The row is getting added(in here 10/19/2017) along with a column full of 0's. Is there a way to hide the column with 0's alone?

Cdate/LOB	Manual	Auto	Referred
10/21/2017	10	0	0	0
10/20/2017	10	35	0	0
10/19/2017	0	0	0	0
10/18/2017	67	6	6	0
10/17/2017	0	78	0	0
10/16/2017	89	0	8	0

I did find this macro which says that we can hide the colum . Could you please let me know how exactly this works? or is there any other way?

sub Squeeze
call HideColumn("CH01", 2)
end sub
'
private sub HideColumn(ch, n)
set ch = ActiveDocument.GetSheetObject(ch)
ch.SetPixWidth (n-1), 0
end sub

Any help will be much appreciated.

Thanks,

Anupama Jagan

[MarcoARaymundo]

Hi! this not possible

[atoz1158]

Hi

You cannot hide a column in a Pivot Table as you can in a Straight Table, if you do not need to use a Pivot Table converted it into a Straight Table and then on the Presentation tab for the table properties you will have an option to Hide the Column.

The best you can do in a Pivot Table is to set the background and foreground colours to be the same for that column and make its width as small as possible.

Regards

Adrian

[Anonymous]

But how to change the colour and width for that column alone? because its doesn't have any LOB attached to it. It just pops up only cos I have generated the missing dates ...

[Anil_Babu_Samineni]

Does this macro using any button?

[Anonymous]

I don't have any information regarding this macro. When I searched for this problem in this below link..

Pivot Column Width to Zero

[MarcoARaymundo]

There is no width control per column, even though the column does not have zero width.

You can change the color to the same from the background.

[Anil_Babu_Samineni]

Would you like to go macro code using button in extra object?

[Anonymous]

Is it not possible otherwise? because the requirement is on opening the document the table should all dates but without that extra 0 column..

[pradosh_thakur]

Well there is a possibility. Give it  a try.

1: go to the expression for that column

2: check conditional show

3: set condition 1=0

regards

Pradosh