How best to Group data

[#1]

Hi all,

Can anyone tell me how I go about grouping data in a table. I have tried the grou by but this doesnt seem to work. Attached is a sample to show what I need.

The reason I need this is I need to use a bubble chart to visualise client pipeline and liklyhood of winning client (pipeline report) At the moment I am showing connected bubbles as the graph treats each line separately so need to combine.

Thanks in advance for any help.

[jagannalla · Accepted solution]

Hello,

Use this code:

Temp:

LOAD [field 1],

     [field 2],

     [field 3],

     [field 4],

     [field 5],

     [field 6],

     [field 7],

     [field 8],

     [field 9],

     [field 10],

     [field 11],

     [field 12]

FROM

(biff, embedded labels, table is [Sheet2 (2)$]);

Main:

LOAD [field 1],

MaxString([field 1]) as Temp,

MaxString([field 2]) as [field 2],

MaxString([field 3]) as [field 3],

MaxString([field 4]) as [field 4],

MaxString([field 5]) as [field 5],

MaxString([field 6]) as [field 6],

MaxString([field 7]) as [field 7],

MaxString([field 8]) as [field 8],

MaxString([field 9]) as [field 9],

MaxString([field 10]) as [field 10],

MaxString([field 11]) as [field 11],

MaxString([field 12]) as [field 12]

Resident Temp

Group By [field 1]

;

DROP Table Temp;

- check sample file if you required.