Hi All,
I would like to show the FY at the start of a time period.
This can be done using 'Show' functionality but I would like to use a dynamic filter that updates based on the current year.
Any thoughts?
Thanks,
Chris
@ChrisAHeathcote
You should be able to use the group position function.
For super advanced dynamic sorting of the hieararchy, there might be a creative way to use @Mark_W_Shemaria idea on identifying the groups first.
https://community.anaplan.com/t5/Best-Practices/Calculating-Levels-in-a-Hierarchy-for-Dashboard-Filtering/ta-p/33567
@JaredDolich
So simple yet I have never had the need to move them.
It's amazing, isn't it? Always something new to learn.
Can't wait to see January's upgrade. I read we're going to be able to pivot the grid without going into design.
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…
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…
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.…