Before we start, here's a quick description of what are simple lists. Then, I will share how each level in a simple list can be flagged.
Simple lists contain list items in a single list with a parent/child hierarchy. For example:
It's often tricky to apply logics to this list because you can only add data to child list items.
In order to flag levels i.e. Identify at which level a given item is, 1 being the topmost level
Like so,
I used "formula" as summary method on the line item calculating the parent of the list and then the following formula to calculate the level:
This little trick can help solve various model building questions around simple list
One way I used it was to highlight levels in my hierarchy diagram
I will be happy to discuss more questions around Simple and Composite lists
Thanks,
Shaivya
