Benson Shaw Posted November 27, 2018 Share Posted November 27, 2018 Worksheet database headers calling valid data cause sub rows (item rows? not sure of name) to appear below the database row. eg 12.1,12.2.12.3, etc. Is there a way to collapse or hide these sub rows and show only the summation values in the header row? thanks! -B Quote Link to comment
Pat Stanford Posted November 27, 2018 Share Posted November 27, 2018 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. 1 Quote Link to comment
Benson Shaw Posted November 27, 2018 Author Share Posted November 27, 2018 (edited) 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 November 27, 2018 by Benson Shaw brevity Quote Link to comment
Recommended Posts
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.