Adding Sizes To Get Multiple Totals In A Single Schedule

[Bryan_Amato]

I'm going to get right to the point. How can I configure my schedule so that it can show multiple totals in a single schedule? For example I want to add all the sizes for my 6"/12" ducts found on my project on the same sheet that I want to add my 8"/12" sizes, however I want an amount for each size not grand total for all amounts together. I have already tried multiple fields and can't seem to figure this one out. When I add the columns vertically it will give me an overall total which is NOT what I want since my ducts are different sizes therefore adding all of them to get a grand total of duct size would be useless to me. I have posted a screenshot down below to give you guys a better idea of what i'm talking about. 

My Revit version is Revit 2017.

If you need any additional information or if I wasn't clear enough please let me know. Thank you in advance.

[ToanDN]

Can you share a file with some of the scheduled items and the schedule?

[andybrack · Accepted solution]

You can get totals for the sub-categories in your schedule.  I created a simple Area schedule using the fields Level, Name, and Area.  The trick is to get add the Footer in the Sorting / Grouping tab. I always thought this an odd place.  To me it should have been in the Formatting tab with the Calculated Values.  Anyway, the same idea should work for your duct schedule.

Sincerely,

Andy Brack

[Bryan_Amato]

Instantly solved my problem. I never thought of adding the footers and adding the "total only" count. Great idea! Thank you for your help.

[Rak.Marcelo]

nice solution!