Filtering by Line Item (List)

Hi,

I have created a filter to my module where users can select an item from the filter, which the module will then show those which apply (via boolean).

However, I cannot seem to show all items? I created a top hierarchy in the list, but my boolean formula is S_Reporting Group Selector.Reporting Group Selector = Reporting Group and so when all is selected, the boolean does not apply. How can I fix this?
Thanks

Accepted answers

Kristina_Mihay

Hello,

you should create a separate Boolean condition 'if selected item = parent(item)' and add it to your final Boolean LI used as a filter.

Best regards

Kristina

All comments

AlejandroGomez

Hi @CommunityMember113484

set the summary method of the line item used as filter to "any" or "all".

Cheers,

Alex.

CommunityMember113484

Hi Alex,
I tried both and it didn't quite work! I think it's because each product is part of a reporting group, so when all is selected, the boolean is not checked?

AlejandroGomez

thanks for the feedback.

As per the formula in your original post, seems to me that your selector is at "Product group" level, whereas your target module is at "product" level? If this is the case, you will have to use a Lookup in your filtering boolean line item: something like this: S_Reporting Group Selector.Reporting Group Selector = Reporting Group[lookup: product group]

Could that be the case?

Kristina_Mihay

Hello,

you should create a separate Boolean condition 'if selected item = parent(item)' and add it to your final Boolean LI used as a filter.

Best regards

Kristina

CommunityMember113484

Thanks this worked!!

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385