Skip to Content

How to sort rows in a table in BO Cloud/SAP Analytics Cloud

Hi, I'd like to build a table resembling a P&L statement. However I'm having a hard time getting the rows sorted in a customized way. Ideally, I'd like to have them the order illustrated in the first image. The order I apply in the filter interface seems to have little effect though as you can see in the second image.

I've seen another P&L that was ranked just fine were only the Default order box was ticked. I am however unable to get the 'break grouping' box unticked to try that out... Does anybody have experience in this regard?

Thanks,

Bjorn

pl-order.png (24.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 04, 2017 at 02:54 PM

    sorting-solved.png

    Got it, sorting should be explicitly done in the hierarchy.

    Thanks,

    Bjorn

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 02, 2017 at 10:08 PM

    What is your data source? I know in SAP ECC we have a financial statement version table that controls the sorting of the P&L and balance sheet statements.

    Add comment
    10|10000 characters needed characters exceeded