Calculating Levels in Hierarchy / Filter out sub-level
We have a 5 level composite list & in the top level (Region L1) there is a sub-composite list (by that I mean there are list items with parents within the same list, i'm not sure of the technical name for this - see attached screenshot where China, Korea & Japan are child parent of Asia, all within Region L1)
I have created a module that calculates the hierarchy level for filtering purposes (screenshot 2) on a dashboard but I wish to filter out the China, Korea & Japan list items in Region L1. Currently all items in Region L1 have 1 as the value
Is there a way to achieve this?