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

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
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".
 
Upvote 0
So, then it is definitely not available in 2000 then? That is what we have where I work...

Thank you for the info!
 
Upvote 0
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)
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

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
Back
Top