Delete or hide the Item "All" in a Pivottable?

[XL-Dennis]

I´ve been trying to find a way to hide/delete the item "All" in the pagefield of a piovttable but so far without any success...

Does anyone know if it possible at all or am I out of luck (as usual)?

TIA and with kind regards,
Dennis

 

[jimboy]

Right mouse over the column and select field, then select the item/s you want to hide and OK.

 

[XL-Dennis]

jimboy,

Sorry, apparently You didn´t read the question...

I´ve been trying to find a way to hide/delete the item "All" in the pagefield of a piovttable but so far without any success...

Does anyone know if it possible at all or am I out of luck (as usual)?

Kind regards,
Dennis

 

[Juan Pablo González]

Dennis, I don't know of a way to do that. XP has a new event regarding PivotTables, refresh I believe, wich, maybe, could be used to change the field selection if the user chose "(All)", but, looping through the .PivotItems collection of the Field page won't give you the "(All)" item, to change its Visible property to False.

You can get the "(All)" by using the .VisibleItems, but, then, it will only appear if (All) is the current selection !, but, couldn't change the Visible property of this one in here !

So, sorry, I guess you ARE out of luck !

 

[XL-Dennis]

Juan,

Thanks for Your reply

With kind regards,
Dennis