Excel Add-in: Filtering options

jk1nn1ck_*20973

Hi,

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.

Before:

After:

Comments

Quentin

Hello,

To select/unselect items at a level and below you can click on the small button on the right (rounded with a checkmark or X inside) instead of the squared checkbox on the left and it will do it for you.

However, I totally agree that it is not the best experience to do it one by one for each item at a level and below - even with this feature - it becomes very complicated and inefficient to use the Add-In when we have large hierarchies. Having the "Select Levels" feature like in the browser version of Anaplan would make it so much easier to use the Add-In in these cases.

This is a nice feature that becomes useful in certain situations, however I believe that it should be complementary to the "Select Levels" option so we have maximum flexibility with our hierarchies.

That would represent a major improvement and definitely an argument in favor of using the Add-In.

Best regards,

Quentin

jk1nn1ck_*20973

"To select/unselect items at a level and below you can click on the small button on the right (rounded with a checkmark or X inside) instead of the squared checkbox on the left and it will do it for you."

--- Okay thanks that helps some I did not know that. Yes, agree with everything you posted. We need a Select Level option like in the browser version.

MagaliP

As explained in the comments, please use the checkbox on the right

MagaliP

Thanks for your comment @jk1nn1ck and @Quentin . I can see you raised this second idea to select levels.

Quick Links

New ideas

Allow non-WSAs to view source module name in UX.
When a user clicks the ellipsis in a grid card they should be able to see the name of the source module. This empowers end users with the ability to connect to the source data they see in the UX to the module in the backend. It also enables end users to pull the data into Google Sheets or Excel.
A function that identifies all saved views which filters are broken
I would like the function to identify all saved views which filters are broken(error).
Add feature to “Use Account Style Drilling” in AnaplanXL Grids
This feature to display children above the parent when drilling in is available in AnaplanXL freeform but not grids. This would be a useful feature in Grids as well. As a user, I would expect to have same/similar functionality between Grids and Freeform.