AnsweredAssumed Answered

Summarize data from a portal

Question asked by braxton on Jul 22, 2012
Latest reply on Jul 23, 2012 by braxton

Title

Summarize data from a portal

Post

I have two tables in a database:

Products

  • ProductName

Stores

  • StoreName - from list
  • Cost

 

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:

Winco:  $10.00

Safeway:  $11.00

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.

products.jpg

Outcomes