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

How to create a row index by characteristic in BEx Query Designer

Hello,

I need to insert a column with row index (row count) - counting the lines where a characteristic is group by. in Sap Query Designer. I'm very sorry I don't expressed myself very clear. I tried to show what I want:

Plant Contract CS Order Value (KF)

7000 100015 5333 66

5222 87

100050 5444 90

7010 100025 5432 67

5666 55

7020...............................

I want to put a row index column in front of Contract like this:

Plant Nr.crt Contract CS Order Value (KF)

7000 1 100015 5333 66

5222 87

2 100050 5444 90

7010 3 100025 5432 67

5666 55

7020...............................

Please, I need this badly, please advise me.

Many thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Apr 24, 2012 at 02:38 PM

    Hi,

    Try this method it might suffice your requirement.

    Go to columns panel and create a new formula and put 1 inside it now hit the Aggregation tab---Exception aggregation as count of all values that are not equal to zero.

    Reference characteristic--contract.

    In calculations tab select the cumulative check box.

    Kindly let me know the output of this approach.

    Regards,

    AL

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello,

      It's not working. The column KF is displayed on the right (as Key Figure) and it shows 1 all over the column (on every line, at CS order value, which is kind of normally). I need to count the contracts, which are on the left side (characteristic) - the cs orders look grouped by contracts and i want to count contracts.

      Thank you for response, maybe you have another idea?! because i don't know what else to do - I don't think is possible to do this task and I'm worry.

      Many thanks in advance.

      R

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.