Just a note to say that I've added new relationships for each category
summary as a work around and it seems to be the answer to gaining a
report that lists the results in descending order.
Lee
Lee wrote:
I tried that Ralph, as the correct totals are displayed in the preview
unfortunately not in ascending order (all over the place), but when it
exports it doesn't keep the separate aggregate totals it just exports
the overall total of all fields. So you get:
category
blue
client ID 551 when it preview report is showing (104)
client ID 551 when it preview report is showing (120)
client ID 551 when it preview report is showing ( 34)
Red
client ID 551 when it preview report is showing ( 21)
client ID 551 when it preview report is showing (272)
I have it all working fine except filemaker will not sort by a summary
field which is my problem.
Lee
Ralph Lilienkamp wrote:
Hi Lee,
try exporting the results to a new table and do the sort and report
from that table.
On Dec 6, 2008, at 4:27 PM, Lee wrote:
I can get the result I require except that it will not sort by the
final total as its a summary field and the sort command will not
sort by a summary field
Lee wrote:
I should have also advised that a number of entries are made with
numerical performance levels for each client for each category by a
number of 'judges'. Therefore there could be 10 scoring 'cards' for
each client to be summarised within each category.
Lee wrote:
Hi,
I have a little difficulty in achieving a simple result.
I have records that contain numerical data.
For example a client name, list of numbers that relate to , say
performance for a specific category.
So I would have (John, 5, 4, 5, 4, 4 totaling 22 in category Blue)
I also have many other clients scoring in a range of other
categories as well as Blue with similar data.
I'm trying to create a summary that will list each category with
the highest performing client and their total for each category in
order of attainment.
I can get a summary list in many ways but not this specific one
I would like to see
Blue Peter Smith 58
Blue John Brown 56
Blue Paul Simon 53
Red John Dixon 88
Red Brian Brown 82
Red Walter Judd 75
etc
Currently I have two tables, one contains client data and a
related table contains the client ID (link). The scores are
entered in the related table.
Hopefully there is a simple answer.
Lee
--
Ralph
--
