cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

anshu_lilhori
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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