Jump to content
Benson Shaw

Worksheet collapse or hide rows

Recommended Posts

Worksheet database headers calling valid data cause sub rows (item rows? not sure of name) to appear below the database row.  eg 12.1,, etc.  Is there a way to collapse or hide these sub rows and show only the summation values in the header row?





Share this post

Link to post

No way that I know of.  Two options:


1.  Pick a field that is the same on all of the items and SUMMARIZE based on that column. That should get you one subrow.  Select the Sum Values option in each column and you should have the same values in the header and the subrow. Hide the headers and you should have what you are looking for.


2. Don't use a database at all and just use the functions with criteria. i.e. =Count((C=;'My_Class'))  Will return the number of objects in the class names My_Class. I don't think you can do this for Record.Field combinations.

  • Like 1

Share this post

Link to post

Great, Thanks, Pat!


I have 27 stainless panels with lattice cutouts, and about 1000 little pieces hanging in the lattice holes. Engineer needs total area and metal weight, but I don't want 1027 rows to show on the worksheet.  I used the blank, perimeter shapes drawn as polylines on their own layer, in their own class.


Made #2 work but with function =Count with the sum and summary options.  Then other columns for area and weight.

Couldn't get any results with=Count((C=;'Bridge3-PanelBlank')).  Maybe it's the hyphen in my class name.


Thanks again.



Edited by Benson Shaw

Share this post

Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114


© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

  • Create New...