In the drill down window being able to filter on values for non blank or non than zero

Hi Anaplan,

It would be amazing if within the drill down view you were able to filter on a list of values for items that are non blank or non zero. So for example if you're looking at a calculation with a dimension that has 1000 items you can see only the relevant items with non zero or non blank values that contributing to the number.

This is something that is regularly brought up as an anaplan issue that needs to be solved.

I hope we can see this functionality very soon!

Thanks,

Usman

Comments

Miran

Status changed to: In Review

Rebecca

Status changed to: In Review

andrewtye

@usman.zia - might be an old one but adding some kudos! nothing worse than as you say having a list of hundreds or thousands with only a few actually there.

although i notice that "quick filter" might be able to do it for you... so potentially could be closed

LilyLiuAnaplan

@andrewtye could you please elaborate on the quick filter? when I am in the drill down view, I cannot see any filter options

andrewtye

@LilyLiuAnaplan : this is in NMX but probably true of classic, you can right-click on the column of data and select filter or quick-filter per the below:

I do see that this isn't possible within the UX.

Quick Links

New ideas

Administration Console: Keep Last login in Date format, on top of new format
It is great to know how old is the Last Login, but: 1.It would be great to keep the old Date format as well, to be able to make more easily some ad hoc analysis (older than X days, months etc…, as shown in example further below). The filter on new format is not possible and would not be meaningfull. 2.It would be great to…
Synchronized Scroll on Worksheet with an Expanded Grid Card
It would be incredibly helpful to have the ability to group the main worksheet grid with an expanded card for synchronized horizontal scrolling. Use Case: In my worksheet, I have the Time dimension on columns and a list on rows in the main grid. I also use an expanded grid card to show a different breakdown—still by Time,…
Line Item Spacing within a Text Box
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Option to adjust line spacing within a text box. Who is this impacting? (ex. model builders, solution architects, partners, admins,…