I have a VFP report with a group. The detail of the group includes a numeric value field. I want to do two things: add a field to the group summary band giving the total count of that numeric field in the detail band above, and I want to add a calculated field next to the numeric field in the band giving the percent that line (record) is of the summ of the band below. For example:
Cars sold in:
New York 5000 50%
California 3000 30%
Texas 1500 15%
New Jersey 1500 15%
_____________________
Total: 10000 100%
I can't figure out how to do this...neither with the report wizard nor using the properties. Does anyone perhaps have a report form they could show me that contains an example of how to do this? Or some other way of explaining it to me?
Thanks!
Jim
Jim Wheelock