Hello,
I there a way/workaround in sorting a nested axis in Anaplan?
Attached is the example module where I need to put the TOTAL LIST1 and TOTAL LIST2 at the start of each list.
Thanks in advance for helping.
Tom
Hey @tompatrick.ting
Actually, there is an easy nifty way to do it, however, I agree it's frustrating that we can't work with nested lists the same way as we do for a single list.
To have the totals of a list appear at the top in a nested list construction, do the following for both nested list (if you need both to have the totals at the top):
Let me know if you face any issues trying to implement the above, or if you have any questions about it.
@einas.ibrahim ,
This is a nice little trick, but if members get added to the list, they will not dynamically show up, correct?
Rob
Hey @rob_marshall
Thanks for pointing this out. It is important.Yes, when and if a new list member is added to a list that has been ordered in the way mentioned, it will not automatically appear.This is because we are basically using the "Show" tool to just show the members you selected, just in a particular order. And that's how the "Show" works.Is there a way that would take into account newly added list members?Or better yet, is there a way - even on the roadmap - that would allow us to individually manage list display options for nested lists.
I know nested lists are a pain and should be avoided, however, sometimes there is no way around it.
Thanks @einas.ibrahim for the alternative, unfortunately we will need a dynamic setup as we will add new list member in the future. Hope there are other workaround.
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…