AnsweredAssumed Answered

How can I move summary fields into another table?

Question asked by juandent on Nov 29, 2017
Latest reply on Dec 1, 2017 by philmodjunk

Hi,

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?

 

Thanks,

Juan Dent

Outcomes