Defining levels on Ragged List
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)
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
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.
Could you kindly provide an example of 'hard coding to the field' as I'm not 100% on what you are referring to