Defining levels on Ragged List

MarkTurkenburg
Contributor

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)

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
MarkTurkenburg
Contributor

Re: Defining levels on Ragged List

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

View solution in original post

3 REPLIES 3
anand.shekhawat
Super Contributor

Re: Defining levels on Ragged List

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
Contributor

Re: Defining levels on Ragged List

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
Contributor

Re: Defining levels on Ragged List

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

View solution in original post