Re: Grouping fields in Discoverer

Its difficult to say without seeing the structure of your table. But you could make
use of the decode function.

Sum( Decode( organization_name, 'ORG1', value ) ) Org1,
Sum( Decode( organization_name, 'ORG2'', value ) ) Org2....
Sum( Decode( organization_name, 'ORG1',0,'ORG2',0,'ORG3',0,value ) ) Others

ps. Decode function can be replaced with the CASE function but I don't have the syntax to hand

"Rl" <lofmanro_at_ineo.fi> wrote in message news:d_zY7.30$AG1.11146_at_read2.inet.fi...
> I have the following problem:
>
> I would like to group the columns that are fetched by an item in
Discoverer
> like the
> following example:
>
> Lets say for example that I am fetching organisations from the database
onto
> the x-axis
> and related information under it.
>
> | Org1 | Org2 | Org3 | The Rest |
> | | | | |
>
> My problem would be here to get "The Rest" of the organisations
information
> summed
> together and displayed in only one column.
> I have tried to implement this by doing a calculated field count(x) etc.
but
> I can't get
> Org1..3 and the calculated field next to each other on the x-axis.
>
>
Received on Thu Jan 03 2002 - 15:27:52 CET