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