Pivot Tables - Remove the "(All)" from the dropdowns

[Guest]

We have a requirement such that it has become necessary to remove the default
"(All)" form the drop down pivot fields lists for one of the pivot tables.

If you really want to know why, we are creating a report in which "All" is
one of the fields in the dropdowns. And that "All" is computed differently
(is not the sum of everything). So, to make sure the users are not confused,
we need to remove the default "(All)" that pivot table puts in.

If this cannot be done, I am thinking of writing some code that will select
our "All" in the highly unlikely event that the user selects the default
"(All)" .

Thank you all in advance for your inputs.
- Peace.

 

[Roger Govier]

Hi

Might it not be easier to choose something other than All as your
option.
Could you not use Entire or Complete.
Search and Replace All with Entire, then refresh the PT.

 

[Guest]

Hi Roger,

Thanks for the input. Yes, it would be easier to use another word instead.
But we are trying to replicate some existing reports and the users want the
"All" option to keep new training to a minimum.

So you think its possible to hide the "(All)" from the drop downs?

- Bhavdeep.

 

[Roger Govier]

Hi Bhavdeep

I do not know of any method to achieve this. Others might.
Perhaps then change All to All Values or anything that is different to
(All)