Problems with expanding or colapsing entries in pivot tables

JoMueHo Unfortunately from what I've read there doesn't appear to be a setting to stop this behavior. When the same pivot items appear in more than one group of the parent field, they will expand and collapse together (when visible). You can, however, start by collapsing the entire parent field ("Years" in this case), then expand one year, month and customer at a time. In the example shown below, I've used years, quarters and months as a quick demonstration:

Collapse entire parent field

Expand one parent item

If you expand two or more years at one time, quarters and months will expand/collapse together for those years. Sorry for the bad news... I realize this is probably not what you were hoping to hear.

For additional info, please see: https://answers.microsoft.com/en-us/msoffice/forum/all/pivot-table-expandcollapse-issue-similar-groupings...