How to merge schedule rows

[Shah_H_]

I found a schedule in our Revit template that has only one row that shows "varies" for the Name parameter and a total of the square footage. please see the screenshot. I need to recreate a schedule in the same way, and I don't want to see all the rows. is there any way to mix all the rows into one in the same way? I'm attaching screenshots only to show what that schedule is made out of. (obviously some of those columns are hidden) 

[barthbradley · Accepted solution]

"Varies" is displayed because the Schedule isn't Itemized.  Check Itemize each Instance under Sorting/Grouping Tab.  Are you saying you don't want to do that? 

FWIW:

[Shah_H_]

No, I don't want Itemized (I want to only show one row similar to that screenshot), and when I change to show varies as you mentioned, it doesn't do anything. 

[SteveKStafford]

A schedule of rooms that all have the same name, sorted by name, set to "varies" will produce a schedule of one row. However, as soon as the sort criteria has more than one value it changes to list each unique name and then the other columns get "varies" they have different values to show in the single row provided.

[ToanDN]

Sorting tab: Uncheck Itemized.  Formatting tab: set the Area field to Calculate Totals.

[barthbradley]

---

@Shah_H_ wrote:

No, I don't want Itemized (I want to only show one row similar to that screenshot), and when I change to show varies as you mentioned, it doesn't do anything. 

---

Did you mimic all of the settings I'm showing in the first 3 screenshots?  

[Shah_H_]

Thank you. I did and it worked.