Hello,


I have built a Pivot table on data stored in a massive table in
another Excel sheet.

I have 5 pagefields, but problem is that I cannot get these fields to
use multi-select (checkboxes). I can only choose 'all' or one specific
value.

Using Excel 2003, is this possible? I have not used any VBA in making
the pivot, only 'regular' excel functionality.


Regards,
-NorTor

If you drag that page field to a row field, make your multiselection, then drag
it back to the page field, what happens?

NorTor wrote:

Hello,

I have built a Pivot table on data stored in a massive table in
another Excel sheet.

I have 5 pagefields, but problem is that I cannot get these fields to
use multi-select (checkboxes). I can only choose 'all' or one specific
value.

Using Excel 2003, is this possible? I have not used any VBA in making
the pivot, only 'regular' excel functionality.

Regards,
-NorTor

--

Dave Peterson

Hi Dave!


That works, though not quite as elegant as having checkboxes in front
of the pagefield dropdown :-)

I guess there is no way than doing a 'shortcut' like this.

Thank you very much!


Regards,
NorTor



On Thu, 12 Jan 2006 09:29:34 -0600, Dave Peterson
wrote:

If you drag that page field to a row field, make your multiselection, then drag
it back to the page field, what happens?

NorTor wrote:

Hello,

I have built a Pivot table on data stored in a massive table in
another Excel sheet.

I have 5 pagefields, but problem is that I cannot get these fields to
use multi-select (checkboxes). I can only choose 'all' or one specific
value.

Using Excel 2003, is this possible? I have not used any VBA in making
the pivot, only 'regular' excel functionality.

Regards,
-NorTor

I usually weasel out.

I insert a new column and use a formula that evaluates to true/false. Then I
just change the formula to what I want, refresh the pivottable and show the
trues.

That helper column formula can be as complex as I need it to be.

nortor wrote:

Hi Dave!

That works, though not quite as elegant as having checkboxes in front
of the pagefield dropdown :-)

I guess there is no way than doing a 'shortcut' like this.

Thank you very much!

Regards,
NorTor

On Thu, 12 Jan 2006 09:29:34 -0600, Dave Peterson
wrote:

If you drag that page field to a row field, make your multiselection, then drag
it back to the page field, what happens?

NorTor wrote:

Hello,

I have built a Pivot table on data stored in a massive table in
another Excel sheet.

I have 5 pagefields, but problem is that I cannot get these fields to
use multi-select (checkboxes). I can only choose 'all' or one specific
value.

Using Excel 2003, is this possible? I have not used any VBA in making
the pivot, only 'regular' excel functionality.

Regards,
-NorTor

--

Dave Peterson

Or, you can double-click on the page field button, and select items to
hide, as shown he

http://www.contextures.com/xlPivot03.html#Page

Dave Peterson wrote:
I usually weasel out.

I insert a new column and use a formula that evaluates to true/false. Then I
just change the formula to what I want, refresh the pivottable and show the
trues.

That helper column formula can be as complex as I need it to be.

nortor wrote:

Hi Dave!

That works, though not quite as elegant as having checkboxes in front
of the pagefield dropdown :-)

I guess there is no way than doing a 'shortcut' like this.

Thank you very much!

Regards,
NorTor

On Thu, 12 Jan 2006 09:29:34 -0600, Dave Peterson
wrote:


If you drag that page field to a row field, make your multiselection, then drag
it back to the page field, what happens?

NorTor wrote:

Hello,

I have built a Pivot table on data stored in a massive table in
another Excel sheet.

I have 5 pagefields, but problem is that I cannot get these fields to
use multi-select (checkboxes). I can only choose 'all' or one specific
value.

Using Excel 2003, is this possible? I have not used any VBA in making
the pivot, only 'regular' excel functionality.

Regards,
-NorTor




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Geez, if there were only some way to get all these tips in a nice consolidated
location.

Oh, my!

http://www.amazon.com/gp/product/159...67040?n=283155

Congratulations!

Debra Dalgleish wrote:

Or, you can double-click on the page field button, and select items to
hide, as shown he

http://www.contextures.com/xlPivot03.html#Page

Dave Peterson wrote:
I usually weasel out.

I insert a new column and use a formula that evaluates to true/false. Then I
just change the formula to what I want, refresh the pivottable and show the
trues.

That helper column formula can be as complex as I need it to be.

nortor wrote:

Hi Dave!

That works, though not quite as elegant as having checkboxes in front
of the pagefield dropdown :-)

I guess there is no way than doing a 'shortcut' like this.

Thank you very much!

Regards,
NorTor

On Thu, 12 Jan 2006 09:29:34 -0600, Dave Peterson
wrote:


If you drag that page field to a row field, make your multiselection, then drag
it back to the page field, what happens?

NorTor wrote:

Hello,

I have built a Pivot table on data stored in a massive table in
another Excel sheet.

I have 5 pagefields, but problem is that I cannot get these fields to
use multi-select (checkboxes). I can only choose 'all' or one specific
value.

Using Excel 2003, is this possible? I have not used any VBA in making
the pivot, only 'regular' excel functionality.

Regards,
-NorTor



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

--

Dave Peterson