Door Schedule Sorting

[Amelia S]

Can anyone tell me how to get my door schedule to sort like this: list each door type once, no matter how many there are, and the height, width, and thickness show up for one door, like 2'-8" x 8'-0" x 1 3/4".

When I list them all individually, these dimensions show as intended. But right now, when I summarize redundant doors, the fields for the doors' dimensions are multiplied by the number of instances of the door. Say there are 3 of those 2'-8" x 8'-0" doors; they show up as 8'-0" x 24'-0". How is this done?

Thanks!

[Pat Stanford]

The first SUM tile you add will SUMMARIZE the database by that column.

Each Additional SUM tile that you add will "UnSum" that column and give you the "average" of all the values that are SUMMARIZED in that row. If they are all identical, you will get the value you are looking for.

[Amelia S]

Interesting! Thank you, that works perfectly.