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.
Hi Vivek,
you could work with a prequery, find out the materials in this prequery (without the sold to) and hand it over by replacemtn path variable to that query where there is the sold to party included.
regards
Cornelia
Add a comment