Counting Unique Records - Pivot Table

[marccantwell]

I have a table that I would like to select a handful of fields from and display the unique combinations of those fields and the count of those unique combinations. Just like a pivot table in Excel. However, I would like to be able to format it so that the unique combination of fields is in a single row with the count at the end.

I have done the subsummary thing a but the layout is terrible.

Any help would be really appreciated

[Søren Dyhr]

Try to study this:

http://www.fmforums.com/forum/showpost.php?post/101800/

and this:

http://edoshin.skeletonkey.com/2006/12/crosstab_report.html#more

--sd