Filter schedule elements

Hi, I was wondering how can I filter elements in schedule so the only element that’s left is the element with highest value?

What have you tried so far?

Revit doesn’t filter in that way. You’d have to identify the element with the highest value and then use another parameter (like a yes/no) to specifically set that parameter to something that can be filtered by within the schedule.

My question would be “Why?” What are you trying to show? How do you want to use that schedule? If you don’t care about the actual element with the maximum value and only want to display the max, then you can turn off “Itemize every instance” and use “Calculate maximum” in the Formatting tab.

My plan was to select an element, such as a duct or pipe, and create a new sheet containing a section view, a 3D view, and a schedule of that specific element. The problem was that, when I ran my program, the schedule would include all pipes or ducts instead of just the selected one. To solve this, I tried filtering. I applied a filter using the “greater than or equal to” condition. When running the program, I would assign a unique value (e.g., 17) to the “Comments” parameter of the selected element. Since that value was the highest, only that element would appear in the schedule.

:nerd_face:

for me it sounds like you more are after create an assembly view

2 Likes