In the given Lighting Fixture Schedule, each row represents a lighting fixture type rather than individual instances, and the “Count” column summarizes how many fixtures of that type exist in the project. To achieve this layout in Revit, two specific actions must be performed in the Schedule Properties dialog:
Deselected “Itemize every instance.”
The Revit documentation explains:
“Itemize every instance. This option displays all instances of an element in individual rows. If you clear this option, multiple instances collapse to the same row based on the sorting parameter. If you do not specify a sorting parameter, all instances collapse to one row.”
By deselecting this checkbox, Revit consolidates identical fixture instances of the same type into a single row — exactly as shown in the exhibit, where each “Type Mark” (A, B, C, etc.) appears once with a summarized Count.
Sorted by Type Mark.
On the same Sorting/Grouping tab, Revit allows users to organize the schedule by a specific field:
“On the Sorting/Grouping tab of the Schedule Properties dialog, you can specify sorting options for rows in a schedule… You can sort by any field in a schedule, except Count.”
In the example, fixtures are sorted alphabetically by their “Type Mark” (A through E). This ensures the grouped and counted results appear in order.
Other options—such as filtering by type mark or adding switch data—do not impact how instances collapse or group within the schedule.
