Summarize data from a portal
I have two tables in a database:
- StoreName - from list
For each prodcut file I have a portal of the stores and their price for the product. I would like to be able to take a found set that has prices from a couple stores and see the total cost to purchase all the products at each store.
In the graphic example I would have the following totals at the top of the layout:
I might even want to do this with a few stores. I only show the top two best prices in the portal that is sorted by price.
I have tried creating all kind of summary field but can't figure this out. Any help would be appreciated. Thanks.