on 04-26-2013 12:02 PM
Hi,
When we run an FBL3N report we subtotal the output by cost centre. The sub-totalling automatically sorts this in cost centre order - we would like to see it in subtotalled value order (ascending or descending) as well as keeping the sub-totalled cost centres intact. Obviously we have tried clicking the header but then that removes any sub-totalling.
We could export into Excel but it would be easier if this could be done directly in SAP.
Does anyone have an obvious answer?
Thanks in advance for your help.
Hi Simon,
Let me explain by screenshot for you.
Example, I have the default layout with subtotal by Cost center like yours (Pic 1)
Then, choose 2 columns Cost Center and Order also, click on Sub total button, the data will be subtotal by Order and Cost center as well, with Cost center is higher level. (Pic 2)
Check again the order of subtotal by choosing Settings > Summation Levels > Choose, you will see the log like pic 3:
If you still cannot do it, please let me know.
Julie
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Sort the value field first and then subtotal the cost center field. Now you should be able to see what you expected. I guess this helps.
Mani.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.