Pick random value for a dimension

[umashankarus]

Hi Experts,

I have table data as below

Number     Description

1               Description1

1               Description2

1               Description3

2               Description21

3               Description31

4               Description32

Expected Result - to pick any one of the description against the number

Number      Description

1                 Description1

2                 Description21

3                 Description32

Can we use below expression ?

=AGGR(Pick(1, [Description]),Number)

Thanks

[vishsaggi]

may be try this?

Random:

LOAD *

Where RandNum = 1;

LOAD *,

     Number&Description AS NumDesc,

     AutoNumber(Number&Description, Number) As RandNum INLINE [

Number,     Description

1,               Description1

1,               Description2

1,               Description3

2,               Description21

3,               Description31

4,               Description32

];

[tamilarasu]

If you really want to use calculated dimension then try,

=AGGR(FirstSortedValue(Distinct [Description],Number),Number)

[fabdulazeez]

Create a Table Chart

Dimension : Number

Measure  : MaxString(Description)