Add ability to collapse field areas in PivotTable Field and Area Side by Side view
With the ability/normal experience of creating many DAX measures in Power Pivot, the Values area of the PivotTable design is now too small to use effectively. Since the Values area only shows about 4 rows it's really difficult to organize fields correctly when try to drag fields around if you've got 10 or more fields in your Values area. (not at all uncommon for Power Pivot users, although certainly not restricted to them.)
With the introduction of slicers, however, we also tend to use the Report Filter area less, and don't usually add as many fields to the row/column areas.
My suggestion is to allow collapsing the individual field areas in the "Field and Area side by side view". This would allow much more space to be assigned to the needed area(s) in order to allow for an easier PivotTable design/maintenance experience.
I have a full write up of the suggested change on my blog at http://www.excelguru.ca/blog/2015/11/02/suggestion-to-improve-the-pivot-table-experience/ including screen mockups.
Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!
ash [MS XL]
drigloff mefistoguru commented
The existing interface for a long time does not correspond to the increased requirements for the convenience of displaying a large number of fields.
Josh Blackman commented
Very good idea, can we get this?
winston snyder commented
Excellent idea Ken! We can get a bit more than 4 rows if we drag the Task Pane to another monitor and grab a corner of the Task Pane Window and make the window as large as possible. Still not enough room sometimes and should be easier rather than dragging a bunch of stuff around and working hard to maximize the window.
Felipe Costa Gualberto commented
I accidently flagged the idea as innapropriate and can't unflagged it. I'm sorry.
Bill Szysz commented
This is very good idea !!!
Agree with Ken -- Very, very, very good idea. - Drewbbc