Gytis Posted October 22, 2016 Share Posted October 22, 2016 I can't figure this out. For a set of objects with a record, how do I limit my database worksheet to show each Item # once only. That is, NOT to show multiple instances of an Item #, just the first that shows up. At present I have each instance of fixtures appearing. Quote Link to comment
michaelk Posted October 22, 2016 Share Posted October 22, 2016 The most common way to do this is to summarize one of the columns. Click on any row header in the database and drag the "Sum" badge to the column you want to summarize by. The worksheet will show a dash for cells that don't have a unified value. hth mk worksheet summarize.vwx 1 Quote Link to comment
Gytis Posted October 22, 2016 Author Share Posted October 22, 2016 thank you michael--exactly what I was looking for, and so easy 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.