Hi Lee,
Looks like you are exporting the grand summary instead of the sub-
summary. When I tried this today I had the choice of what Summary to
export.
On Dec 6, 2008, at 8:19 PM, 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
--
Ralph
