digitalcarbon Posted June 23, 2009 Share Posted June 23, 2009 can i have a parts list that only lists the item once but some how gives me the count? i am aware that i can count symbols but if i have data attached i want to mine that data. take the attached image. if i had 4000 of those items then it would list it 4000 times. i am fortunate i have only 4. Quote Link to comment
digitalcarbon Posted June 23, 2009 Author Share Posted June 23, 2009 got tech support working on it. will post reply. Quote Link to comment
islandmon Posted June 23, 2009 Share Posted June 23, 2009 did you try > database>column>SUM Quote Link to comment
MattG Posted June 24, 2009 Share Posted June 24, 2009 You just have to highlight your database header row. So if all your database entries are 2.1,2.2,2.3 and so forth click on row 2 and it should highlight. You should then be able to drag the SUM button at the top of the report to that column you want to summarize, so by part type or supplier or whatever. Then if in a empty column you type =count you can get it to count how many of each instance are there. Matt Quote Link to comment
Pat Stanford Posted June 24, 2009 Share Posted June 24, 2009 Actually, you can select any row (or more than one row) in the database and then drag the Sum or Sort (bar chart) icons to the Column headers. Quote Link to comment
digitalcarbon Posted June 25, 2009 Author Share Posted June 25, 2009 thank you! thank you! thank you! i have never been able to figure this out. i knew about the sum tool but not how to do a count column 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.