I have a product layout that summarizes results of a found set based on a "ProductType" field. I would like that layout to also reflect for each product type the percentage of the total in that found set of sales.

For example, with what I have now, I can search for any date range of sales and then get results like this:

Food 45 $5300

Drinks 25 $2700

Cutlery 30 $1500

Then trailing grand summary part gives total items and total dollars. I'd like to display % of items and dollars for each product type, relative to the found set.

Do you mean you want the % of the product type over the total found set?

Like Food is 45 and the % will be 45/100, 45%, 5300/9500, 55.79%.

If yes then the solution will be

create a calculation field, set it as total_items/sum_items*100

and create another one for dollars.

You also can use Round function to set it to 2 decimal.

Regards,

Henry

Forgot to mention an added twist. In this layout, I'm actually looking to compare the sub-summary of a field with the grand summary of the same field.

So I have one field called TotalPrice which is a summary field of Price. So for the layout, on the sub-summary each product type displays TotalPrice, which is the total price for that product type when sorted. Then, I have the grand summary of TotalPrice at the bottom. So what I'm looking for is the following, as a percentage:

Sub-summary of TotalPrice / Grand Summary of TotalPrice

Have you seen this TechInfo article?

http://www.filemaker.com/ti/102198.html

Oh, thanks! I'll check that out.