Pivot Pagefield multi-select? (Excel 2003)

  • Thread starter Thread starter NorTor
  • Start date Start date
N

NorTor

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?
 
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
 
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.
 
Haha, nice one!

In fact I was searching through Amazon just minutes before posting my
original post; and ended up ordering exactly your book Debra! Really!

Thank you both for your tips, I was aware of the 'hide' possibility;
will stick with one of your suggested solutions until Office 12 is out
(I hear this has the checkboxes also for pagefields).


Best regards,
NorTor




Thanks!
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic PageField Items 2
Pivot Table: Optional Page Field 1
Members in a PageField 1
Pivot Multi Page Diff Change 2
Pivot Table PageField 4
Creating an Excel Pivot Table using COM in C# producing 0x800A03EC 0
EnableItemSelction on Page Field in 2003 VBA not working 4
Omit page with no data when use "show page" 4

Back
Top