I have a lot of pivot tables populated from SSAS cubes. Some have expand/collapse buttons for only some of their fields (not the first or second field but then for every other field).
I know how to enable and disable expand/collapse buttons for the whole pivot table (e.g. Excel Pivot Table - Deactivate colapse/expand function), but I would like to be able to remove the expand/collapse buttons for just some of the columns in my tables.
The only information I've been able to find about why some fields might not show expand/collapse buttons when they are enabled for the pivot table is this little comment on Microsoft's support page about enabling and disabling expand/collapse buttons:
NOTE: Expand and collapse buttons are available only for fields that have detail data.
An acceptable answer might be just to explain what that note means :)