Skip to Content

FICO: possibility to sort subtotals by category?


I'm quite sure we can manage it but really can't find how to do it.

I'm using SAP transac: cost centers : actual / plan / variance as shwon below

In order to make quick analysis by P&L line, I'm doing a subtotal by vendor name. please see below

Once I get this synthetised view, I would like to have the possibility to sort the subtotal "value in obj. currency" without loosing my subtotal done by "name of offsetting account" = vendor - such as I could do in in pivot table.

do you guys know this tip?

A big thanks in advance!

capture1.png (114.4 kB)
capture2.png (39.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Oct 29, 2019 at 02:15 PM

    You can sort the values in "value in obj. Currency" but this will sort the single line values not the subtotals, as far as I know there's no way to sort subtotals as a sum

    Add a comment
    10|10000 characters needed characters exceeded

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.