Sub-summary report needing to show value where none exists

[321]

Hi all,

I have a sub summary report I would like to display 0 values on. It is a simple table that is summarized by product category with an amount for each category. Filemaker only summarizes what is in the found records. I would like it to summarize all 4 product categories even though some product categories have no value in the amount field to summarize. See the example below.

This is how it summarizes:

Category Amt

Product A $1000

Product C $2000

This is how I would like it to summarize:

Category Amt

Product A $1000

Product B $0

Product C $2000

Product D $0

Any advice would be greatly appreciated.

Thanks!

Eric

[mr_vodka]

A subsummary report can not group on values that do not exist. That being said, you may be able to generate a report like this from your products table if your solution is properly structured.