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.

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.

--
Regards

Roger Govier


"BhavdeepSachdev" wrote in
message ...
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.

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" wrote:

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.

--
Regards

Roger Govier


"BhavdeepSachdev" wrote in
message ...
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.

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)

--
Regards

Roger Govier


"BhavdeepSachdev" wrote in
message ...
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" wrote:

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.

--
Regards

Roger Govier


"BhavdeepSachdev" wrote
in
message ...
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.