Hello,
I would like to ask if there's a way to make the drilldowns in Anaplan to only show items with data on them <> 0, or isnotblank? Currently, I need to scroll down a lot to locate to the account that has the relevant data.
Thank you,
Jonathan
Currently, there is no option to indicate this in Anaplan. (as far as I know).
Drilldown functionality is quite complex and is not always applied from totals to its children. It is also used to show all the input components of a formula and the zero values have sense to be shown.
However, it would be very useful after the drill-down is triggered, on the windows opened, to be possible to apply a filter.
There are some ideas that are related to this topic that can be kudoed:
https://community.anaplan.com/t5/Idea-Exchange/Enhanced-NUX-Drill-Down/idi-p/109720
https://community.anaplan.com/t5/Idea-Exchange/In-the-drill-down-window-being-able-to-filter-on-values-for-non/idi-p/41788
@alexpavel , thank you so much. These requests would be very helpful! Looking forward to it. Thanks!
Hello there, we are using AnaplanXL to pull data from 3 different sources into one Excel file. Two of them are Azure SQL data bases and the third is Anaplan itself. Whenever the Excel is opened 3 pop up windows to log in to each data base appear. Until they appear and everything is entered or clicked already 2 minutes are…
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…