Excel Add-in: Filtering options
The Pivot & Filter's Filter dropdown functionality does not operate how most people (generalizing) are used to dropdowns working in hierarchical list . Please see screenshots below. Here I have regions, manager names, apartment properties, and floorplans coming from anaplan in a hierarchy. When I uncheck an item at a higher level in the hierarchy, it only unchecks just the one item, rather than everything underneath that level of the hierarchy.
This can make the selection of items extremely cumbersome when there are hundreds of items in the list and I need specific levels of the hierarchy selected an deselected quickly. It is a literal 1 for 1 on the check boxes right now instead of selecting/deselecting by hierarchical level. If we could change how this operates I think it would be a needed improvement.
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!