Excel Add In Filtering for Base Members Only

Hi All,

Has anyone come across the ability to filter only for base members against a hierarchy in the Anaplan excel plugin instead of having to manually deselect all the parents them each time?

The alternative is that I can think of is creating a saved view that only shows base members of the list, however the downside (and the reason why I most likely won't go with this approach) is that the end user is unable to pivot and do ad-hoc analysis via the excel add-in.

Regards,

Winston

Accepted answers

All comments

Misbah

@wquan

I don't think so that there is direct way of doing so. However we have one option of selecting or deselecting the entire hierarchy on top right corner of the filter. Probably you may want to select that and uncheck other parents.

Thanks,

Misbah

karank_*4578

Hey Winsent ( you know who this is 😛 )

You can possibly use an excel macro to hide BOLD rows (parent items)

Something like below

Sub showbold()

Application.ScreenUpdating = False

ActiveSheet.DisplayPageBreaks = False

For r = 1 To ActiveSheet.UsedRange.Rows.Count

Cells(r, 1).EntireRow.Hidden = Cells(r, 1).Font.Bold = False

Next r

End Sub

wquan

I definitely know who this is 🙂 Thanks for that option... never thought about it. Bit annoying still given there's also a 1 million cell count limit so it bumps it up on loading it into excel, will try it out and see if our stakeholders are OK with it!

wquan

Thought so! Just making sure I wasn't going crazy.

MagaliP

These are great workarounds indeed. @wquan , please feel free to post your suggestion for enhanced filtering functionality on the Idea Exchange

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…