About sorting

[Javid88]

Hello everybody,

I have a column named Con_TYPE in which there are multiple types of connections such fiberoptic, satellite, 3g etc.

and i want to sort them only into 2 rows    fiberoptic (for example) 5

                                                                                    and others                          115

can anybody help me?

Thanks in advance

[BrunPierre]

Assuming its grouping you intend then maybe like this

In script:

IF(Match(Trim(Con_TYPE) ,'fiberoptic'), 'fiberoptic', 'others') as [Connection Type]

As a calculated dimension

IF(Match(Trim(Con_TYPE) ,'fiberoptic'), 'fiberoptic', 'others')

[BrunPierre]

Assuming its grouping you intend then maybe like this

In script:

IF(Match(Trim(Con_TYPE) ,'fiberoptic'), 'fiberoptic', 'others') as [Connection Type]

As a calculated dimension

IF(Match(Trim(Con_TYPE) ,'fiberoptic'), 'fiberoptic', 'others')

[Javid88]

I tried it but not working ((((

[BrunPierre]

LOAD *,
IF(Match(Trim(Con_TYPE) ,'fiberoptic'), 'fiberoptic', 'others') as [Connection Type];

LOAD * Inline[
Con_TYPE,Number 
fiberoptic,5
satellite,15
3g,100];

O/P

[Javid88]

Thanks