Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi! this not possible
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
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 ...
Does this macro using any button?
I don't have any information regarding this macro. When I searched for this problem in this below link..
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.
Would you like to go macro code using button in extra object?
Is it not possible otherwise? because the requirement is on opening the document the table should all dates but without that extra 0 column..
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