0

Multiple IsDescendant Filters

Is it possible to select multiple values for filtering by descendant hierarchy?  As an example, I have a list of companies with a hierarchy setup.  I would like to apply a filter with multiple parents selected.  I can get it to filter by one but not multiples.

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Joe Steinbrunner it isn't possible to pick multiple values using the Insight filter editor on a column but you can achieve the same by using a formula in the Insight filter. Would this work for your use case? Example:

    or(
        descendantOf(
            Sales_Hierarchy.Sales_Hierarchy.ID,
            1001
        ),
        descendantOf(
            Sales_Hierarchy.Sales_Hierarchy.ID,
            2003
        )
    )
    Like
    • Thank you Dustin Basil .  Yes, that appears to work for me.  Not quite as intuitive for a business user but glad there is a way to show them.  Thank you for your response.

      Like
Like Follow
  • Status Answered
  • 5 mths agoLast active
  • 2Replies
  • 11Views
  • 2 Following