View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
yowzers yowzers is offline
external usenet poster
 
Posts: 35
Default 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.