How to use dimension limits on this?

[MuraliPrasath]

Hi QV Team,

I need to sort only the first three "Types" of the "Sales" numbers. Please see the attachment.

Example:

SALES	Type
60000000	ZWTY
60000001	ZWTY
60000002	ZWTY
10137211	ZKB3
10137402	ZKB3
10137612	ZKB3
10002852	ZKE
10002928	ZKE
10003576	ZKE
10136417	ZKEF
10136425	ZKEF
10136450	ZKEF
60007972	ZKR
60017742	ZKR
60021333	ZKR
60068576	ZLCR
60069207	ZLCR
60069828	ZLCR
70019690	ZLCS
70019691	ZLCS
70019698	ZLCS

[awhitfield]

Hi MUrail,

do you mean the three Types with the  highest sales values? Like this:

Andy

[sibideepak]

Hi ,

Can you post your expected output for this ??

[MuraliPrasath]

Yes, I need only the First three Types from each SALES.

Example:

ZWTY

ZWTY

ZWTY

ZKB3

ZKB3

ZKB3

ZKE

ZKE

ZKE

ZKEF

ZKEF

ZKEF

[MuraliPrasath]

Please see the attachement and my expected is like this.

SALES	Type
60000000	ZWTY
60000001	ZWTY
60000002	ZWTY
10137211	ZKB3
10137402	ZKB3
10137612	ZKB3

…. All the way down.

[krishna20]

Hi,

Please follow up the following thread .Hope it helps.

Rank function in expression

Regards

Krishna

[MuraliPrasath · Accepted solution]

Never-mind !! I figured it out.