Skip Filter For first field

Hi Experts,

We have a requirement where we need top 3 highest values of a single field, and skip filter for the SoldToParty field let me tell with an example.

MaterialType Material SoldToParty Quantity

M1 MA1 C1 100

C2 50

C3 100

C4 500

M1 MA2 C1 10

C2 50

C3 200

C4 150

M1 MA3 C1 100

C2 10

C3 20

C4 250

M1 MA4 C1 100

C2 150

C3 200

C4 50

From the above we need to pick Top 3 highest sold Material and all the SoldToParty of those top 3 Materials. This is like we need to apply Top N condition only on Material.

This can be achieved by applying condition in BEx query.

Now the next requirement is to display SoldToParty in the 1st column (This Is the Problem which needs suggestion). As Follows.

SoldToParty MaterialType Material Quantity

C1 M1 MA1 100

C2 50

C3 100

C4 500

C1 M1 MA2 10

C2 50

C3 200

C4 150

C1 M1 MA4 100

C2 150

C3 200

C4 50

In normal scenario if SoldToParty is placed 1st the data will be sorted by SoldToParty and the required output pattern is lost.

Please give your valuable suggestions.

Regards,

Vivek.