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

[b_goedhard]

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

[b_goedhard · Accepted solution]

sorting-solved.png

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

Thanks,

Bjorn

[JohnL · Accepted solution]

Hi Bjorn,

Yes the drag and drop features are great in the modeler.

[TammyPowlas]

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.

[b_goedhard]

Hi Tammy, thank you forweighing in!

It's not a connected model but one build from a flat excel file.

I'm somewhat new to the environment..