on 04-24-2012 2:04 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.