How to filter line items

Options
myasuda
myasuda Member, ALL USERS Posts: 5 Master Anaplanner of the Year
in Planning & Modeling

Hi,

 

We have hierarchy type lists of Market Unit and Country Group (Market Unit is parent.) and Country Group list is specified as a dimension of a module. In the module, the line item 'B' is applied to Market Unit.('Applies to' of the line item 'A' is left default.)

 

In such a situation, if user selects one of the Country Group in the Page selector in the module, the line item 'A' only needs to be shown ('B' should be hidden.) When one of the Market Unit is selected, 'B' only needs to be.

How can we do this?

 

Best Regards,

Maki Yasuda

Tagged:

Comments

  • myasuda
    myasuda Member, ALL USERS Posts: 5 Master Anaplanner of the Year

    Hi,

     

    Thank you for your helpful advice and screenshots attached.

    However, 'Applies to' column in blueprint of the line item 'B' is set to 'Market Unit'. On the other hand, one of  'A' is 'Country_Gourp' (left defalut). So IF formula you mentioned cannot be put because dimensions of 'A' and 'B' are different. Error message has been shown as the attached screenshot.

     

    Thanks and regards,

    Maki

  • myasuda
    myasuda Member, ALL USERS Posts: 5 Master Anaplanner of the Year

    Hi,

     

    Your advice is very helpful for me.
    I also understand that 'Summary' settings is important for accurate calculation.

    Thank you for your support!

     

    Best regards,

    Maki

Categories