Suggestion - Excel Add-in ver. 4.0 - Pivot & Filter - Filter Functionality
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.