In a message dated 99-01-08 12:07:00 EST, you write:
Now that I have it sorted I would like to filter on it. However it
doesn’t show up in the simple filter list and when I try to use it in a
complex filter I get an error saying “cannot use aggregate in complex
filter”. Any ideas?
Greg Mills
Greg:
The only way that I have found to get around this is to use the “Rank”
feature. It’s not really the same, but it’s the only way to “hide” values
based on an aggregate calculation.
It goes back to how the filtering / aggregating process works. First the
filter is applied (before any rows are displayed), then the aggregation is
done. So there is no way to aggregate prior to a filter, because the filter
will affect how the aggregation is done. It’s a “chicken or the egg” kind of
question. So, to avoid this loop, BusObj simply does not allow you to filter
on an aggregate.
Now that I have it sorted I would like to filter on it. However it
doesn’t show up in the simple filter list and when I try to use it in a
complex filter I get an error saying “cannot use aggregate in complex
filter”. Any ideas?
WHAT exactly do you want to get??
It seems to me as if you want to show something like the top n or bottom n groups
of values, because sorting on the count() and then filtering (on what???) on the
“first n” or “last n” values is the same as “top n” or “bottom n”…
I’m sure there is a way to accomplish what you need, but you should tell us all of
it and not just one piece after the other…
Walter
Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna, Austria
Tel. +43-1-8151456-12, Fax: +43-1-8151456-21
e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at
> I'm sure there is a way to accomplish what you need,
> but you should tell us all of
> it and not just one piece after the other...
I’ll be sure and pass that on to the user who first requested a sort and
then after I provided that (thanks to the good people of the list),
requested that in fact it be filtered based upon the same value.
> It seems to me as if you want to show something
> like the top n or bottom n groups of values, because
> sorting on the count() and then filtering (on what????) on the
> "first n" or "last n" values is the same as "top n" or "bottom
n"…
This assumes the value of “n” is fixed and known. A filter is based upon
the data values and not the number (n) which meet the filter
criteria.
> WHAT exactly do you want to get??
A report whose data provider is an Excel spreadsheet which shows each
meter # which occurs in more than one row in the spreadsheet. A
descending sort on the count puts them at the top of the report. A
filter shows ONLY those that occur multiple times.