Try doing a search for filtered portals. What version of FileMaker are you using?
Hey thanks for the answer.
I was using FM 10 but I found out that FM 11 portals can filter results so I downloaded the FM 11 demo, the problem is the summary field keeps summing all the data even the filtered data.
I created the summary field in the Dues (Cartera in spanish) table
I think I´m going to cry, thank you very very much.
To summarize I created a field in the Dues table with type summary that calculates the sum of the ¨Value¨ field of each due then I created a new layout that links to the Holdings table and it has two portals one of multiple rows and another one below with just one row that links to the first summary field that I created. Both portals have the same filters, in this case they are filtering any due that has a paid date which means it is paid.