Cameron Posted July 23, 2015 Report Share Posted July 23, 2015 Hi everyone! I have a table that contains about two thousands records (and I hope it will contain more in future). In this table, I have a "Category" field. Is it possible to aggregate the count of records of every category (now I have nine categories, but it will be more in future)? I have tried to use Groups, but I can display only 999 records per page, so I need to goes from page to page to see all categories. Any ideas are very much appreciated! Thank you for your time! Quote Link to comment Share on other sites More sharing options...
0 Aurora Posted July 23, 2015 Report Share Posted July 23, 2015 Hello Cameron ! I have resolved the similar issue. To display the Report more accurately , i have selected “Combined Chart and Report†DataPage and selected Pie as a Chart Type. On the " Configure Result Page Field" enable collapsing data grouping by your field . Now the Pie Chart counts amount of records for each category and the report shows all records in group collapsed by category. I hope it helps you. Quote Link to comment Share on other sites More sharing options...
0 Cameron Posted July 24, 2015 Author Report Share Posted July 24, 2015 Hi Aurora, Thank you for your answer! I did not think about a Chart or a Combined DataPage... Yes, it helps! Thank you for your time! Quote Link to comment Share on other sites More sharing options...
0 EdTheStatMan Posted July 27, 2015 Report Share Posted July 27, 2015 Cameron, what type of database are you building? You have the same types of questions that I have. Quote Link to comment Share on other sites More sharing options...
0 Cameron Posted July 27, 2015 Author Report Share Posted July 27, 2015 Hi Ed, Really? I try to create a catalog of my library, with genres, places where I can find a book, etc. It's a rather boring work to fill it, so sometimes I select incorrect genre or place. These mistakes make the whole catalog incorrect, but it's too boring to recheck every record. Now I check every twenty last records that I've added to be sure that all books are entered correctly. Can I ask, what type of database are you building? Quote Link to comment Share on other sites More sharing options...
0 EdTheStatMan Posted July 30, 2015 Report Share Posted July 30, 2015 Sports Statistics Quote Link to comment Share on other sites More sharing options...
Question
Cameron
Hi everyone!
I have a table that contains about two thousands records (and I hope it will contain more in future).
In this table, I have a "Category" field.
Is it possible to aggregate the count of records of every category (now I have nine categories, but it will be more in future)?
I have tried to use Groups, but I can display only 999 records per page, so I need to goes from page to page to see all categories.
Any ideas are very much appreciated!
Thank you for your time!
Link to comment
Share on other sites
5 answers to this question
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.