Help to Reset Pivot Table

Use this forum for any general discussion and questions about Excel
Posts: 1015
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Help to Reset Pivot Table

Postby MattAllington » Fri Feb 06, 2015 7:25 am

I have a pivot table connected to a power pivot data model. I have products on rows and the products are set up in a hierarchy in the data model. The net result is that I have expand/collapse buttons on rows (see image)
hierarchy.png (10.18 KiB) Viewed 4599 times

The problem I have got is how to reset the expand collapse buttons back to "All Collapsed". It is easy to get the top level to collapse, but when I expand it again, all the previous expanded levels return to the expanded state. This is not what I want. I want a way to reset the pivot table so that all levels are collapsed back to the fully collapsed level so the user can start drilling into the data again. I assume there is a way to reset this but I can't find it in Excel and I can't find it on the web.

Any ideas?
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

Posts: 161
Joined: Tue Sep 09, 2014 8:13 am

Re: Help to Reset Pivot Table

Postby PhilC » Tue Feb 17, 2015 9:29 am

Posts: 1
Joined: Wed Sep 28, 2016 7:46 pm

Re: Help to Reset Pivot Table

Postby ella.uther » Wed Sep 28, 2016 7:47 pm

newbie here.

Return to “Excel”

Who is online

Users browsing this forum: No registered users and 0 guests