Autodesk Revit MEP

[#1]

I am trying to schedule all Flex Duct in my project and group according to the size & model number, which I have done... but I would like a total length of each type, rather than a total length of each piece of flex.  See attached schedule... rather than showing (6) separate pieces of 6" diameter flex duct with separate lengths, I would like to show a total length of flex duct needed, since it comes in 25 foot lengths.  Can someone help me with this?

Thanks,
Jess

[#2 · Accepted solution]

In the schedule settings:

Sorting/Grouping tab

• Uncheck "Itemize Every Instance".
• Sort by Model, and then by Overall Size.

Formatting tab

• Click on the Length parameter and then check the Calculate Totals box.