Jump to content

Worksheet collapse or hide rows


Benson Shaw

Recommended Posts

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
Link to comment

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.

 

-B

Edited by Benson Shaw
brevity
Link to comment

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.

Guest
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.

×
×
  • Create New...