Defining levels on Ragged List

Hi team,

Is there a method to define levels within a ragged list? I have a ragged list which is being used in a complex filtering exercise & for 1 of the conditions I want to only display the Lower level of of the ragged list (see screenshot whereby both Income and Profit & Loss are L1 but I wish to create a condition for Income only)

ScreenShot1_111519.PNG

Accepted answers

MarkTurkenburg_*56377

If anyone is interested in the solution to defining the top level (from L3 of the hierarchy) of a Ragged list it was possible by:

- Creating a COUNT line item in the L3 Properties module (Calculation = 1)

- Creating a 'GL Groups L1 P&L Count' module (No dimensions) where I referenced the COUNT line item above & used SELECT to reference the top list item in L1

- Creating a Boolean line item in the L3 Properties module (Calculation = COUNT = Line item from above) & SUMMARY set to Formula

This results in 1 TRUE item being on the Top list item. I can then use this in my filtering module which is dimensionalised by L3

Screenshots attached

Thanks

Screenshot1_111663.PNG

Screenshot2_111663.PNG

All comments

anand.shekhawat

Hi @MarkTurkenburg ,

You cannot define levels in a ragged hierarchy because their leaf items do not have a uniform number of ancestors. Or we can say that these are unbalanced hierarchies.

In your case, if you want to create a condition where only the 'Income' list item needs to be displayed, you need to hard code the field.

~Anand

MarkTurkenburg_*56377

Thanks @anand.shekhawat

Could you kindly provide an example of 'hard coding to the field' as I'm not 100% on what you are referring to

Thanks!

MarkTurkenburg_*56377

If anyone is interested in the solution to defining the top level (from L3 of the hierarchy) of a Ragged list it was possible by:

- Creating a COUNT line item in the L3 Properties module (Calculation = 1)

- Creating a 'GL Groups L1 P&L Count' module (No dimensions) where I referenced the COUNT line item above & used SELECT to reference the top list item in L1

- Creating a Boolean line item in the L3 Properties module (Calculation = COUNT = Line item from above) & SUMMARY set to Formula

This results in 1 TRUE item being on the Top list item. I can then use this in my filtering module which is dimensionalised by L3

Screenshots attached

Thanks

Screenshot1_111663.PNG

Screenshot2_111663.PNG

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
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.…