Expand/Collapse in Pivot Tables
Is there any way to put in a button to expand and/or collapse groups of
grouped items in pivot tables? I know in regular spread sheets, there are buttons on the left hand side of the sheet called 1, 2, 3, etc. which will expand/collapse the entire level 1, 2, 3 groups of items. Looking for something similar in pivot tables. |
Expand/Collapse in Pivot Tables
Sure! See my example he
http://www.mediafire.com/?4zzztyzjdjg -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "yowzers" wrote: Is there any way to put in a button to expand and/or collapse groups of grouped items in pivot tables? I know in regular spread sheets, there are buttons on the left hand side of the sheet called 1, 2, 3, etc. which will expand/collapse the entire level 1, 2, 3 groups of items. Looking for something similar in pivot tables. |
Expand/Collapse in Pivot Tables
Maybe I am not looking at it wrong or I didn't explain myself clearly, but I
don't think this is what I am looking for. I know pivot tables automatically create individual expand/collapse buttons. What I am looking for is entire groups to expand/collapse. For example: Level A: January Level B: Sunday Level C: Morning Level C: Night Level B: Monday Level C: Morning Level C: Night Level A: Februrary Level C: Morning Level C: Night Level B: Monday Level C: Morning Level C: Night I am looking for a single button that will expand/collapse all Level C items simutaneously. Another button for Level B, and another button for Level A. "ryguy7272" wrote: Sure! See my example he http://www.mediafire.com/?4zzztyzjdjg -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "yowzers" wrote: Is there any way to put in a button to expand and/or collapse groups of grouped items in pivot tables? I know in regular spread sheets, there are buttons on the left hand side of the sheet called 1, 2, 3, etc. which will expand/collapse the entire level 1, 2, 3 groups of items. Looking for something similar in pivot tables. |
All times are GMT +1. The time now is 10:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com