Is it possible to display different line items in one module for different levels of a hierarchical

KacperSzafranski13

Hello,
I created a module that has a hierarchical list structured as below:

I added line items to the module such as:
-Revenue
-Lattitude
-Profit
-Count Active
-Count Closed
-Count Open
But it is not important what line items I have, what is important for me is how to make it so that after selecting, for example, an item from the Region level, only Revenue from all line items is displayed, then after selecting an item from the country level, other selected line items. Is it possible in Anaplan.

Here I have a location in the filter and I want to see not all but only selected line items for it, then I choose a higher level for which I would like to see other line items chosen for this level.

Rnilsson

Hi,

Yes it's possible you need a few modules to fix this.

You need a Line item subset (liss) of the module you want to change line items on.
Then you need a hierarchy logic and I would sugest:

https://community.anaplan.com/discussion/33567/calculating-levels-in-a-hierarchy-for-dashboard-filtering

I will refere to this item as SYS G3 Level

One Lookup Module - will be a field selector on the ux. You should have the logic:
Selection - (use as field selector) - format as List: G3
Hierarchy Level selected = SYS G3 Level[lookup: Selection]

Filter Module based on G3
Level to show = If Selection Blank then true else hierarchy level selected = SYS G3 Level

Based on the list level. you set up a filter logic
in a new module dimensioned by the LISS.

That say
Filter G1- Boolean check the Line items members you want to show on G1
Filter G2 -
Filter G3
Total Filter: if Hierarchy Level selected = 1 then G1 Filter else if ….

Then publish the module with the LISS instead and filter by both the G3 Filter and Liss filter.

Hope this helps