cancel
Showing results for 
Search instead for 
Did you mean: 

FBL3N sort a sub-total in order of value.

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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.