How do I show only those line items which have non zero values for list and time dimension?

I want to see only those line items which are not equal to zero from a hierarchy list subset in a module dimensioned by time as well.

I am looking forward to create a line item which I will apply as a filter to the module.

I have 15+ line items but the filter should only show those line items from the list subset for every list subset item which are having values <> 0 across the time horizon if any week is non zero.

Accepted answers

All comments

alinabrophy

Are you looking to apply this filter on a page or on in the module only (backend of the model)?

harish_bk

Option 1: Use filters on parent time members

Option 2: AS you said you can use additional line item seperately for filter purpose and bring the total time value,
1. Try to keep the lineitem boolean formatted
2. If the value is <> 0 then true and use it for filter
3. If the time horizon is more than 1 year use select time.all periods function but make sure you have selected "Total of all periods" in time dimension (Might have size implications) so better to do in Time Ranges and use that range in this module

Quick Links

Can you help?

Unanswered questions

I am getting error while submitting the assignment,please give me suggestion.
Please suggest why it is not taking submit.
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
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.…