Pivot Table - collapsable lists?

joi

New Member
Joined
Jan 12, 2004
Messages
2
Can anyone tell me how to create a pivot table that has multiple grouping levels in a collapsable list?
I have a client that wants to create a pivot table like one he has seen on the intranet. The drop down lists for the field where the checkboxes are to turn on/off values, have plus signs to the left, where they can collapse and expand to different levels and turn on and off values within the levels. I have not seen this before and cannot find any information on it. I wonder if it is a feature of Excel XP or 2003, that is not available in Excel 2000...

I would appreciate any help!

Thank you
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

TommyGun

MrExcel MVP
Joined
Dec 9, 2002
Messages
4,202
I know this exists on 2003, but I can't remember if it was part of 2002 or not.

Easiest way to create it...tell him to upgrade. :devilish: J/K

Seriously though, I think that trying to "manually" recreate this will be very time consuming and possibly very "grouchy".
 

joi

New Member
Joined
Jan 12, 2004
Messages
2
So, then it is definitely not available in 2000 then? That is what we have where I work...

Thank you for the info!
 

TommyGun

MrExcel MVP
Joined
Dec 9, 2002
Messages
4,202
Juan Pablo González said:
Correct, that's new in XP.
Thanks for the clarification JPG. I did not use XP for very long, so I couldn't remember if this feature was there. (y)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,096
Messages
5,768,061
Members
425,451
Latest member
JohnBrooksBiddle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top