I have a table called StatementLines which has a Category and money amounts fields. It also contains several summary fields that calculate for instance the total lines and the total money amounts for each category. For this to work I need to sort the table by Category.
Now, I need to chart [Category, count of lines for category, total money for category] in different orders (say by descending total money amounts). So, I cannot do this with my existing table - seems to me I need to create another table with the summary fields and then do the sorting on it to display the summarized data per category in a chart.
What is the best way to do this? Is there some way to hace FileMaker Pro 15 Advanced move this data for me somehow? Or do I need to write a script?