Skip to Content
author's profile photo Former Member
Former Member

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Dec 10, 2014 at 09:46 AM

    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
    10|10000 characters needed characters exceeded

  • Posted on Dec 10, 2014 at 04:51 PM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.