Skip to Content
avatar image
Former Member

SAP BI/BO - Sort based on break's subtotal

Good afternoon,

I have a structure which has two breaks, then I add the percentual value for a specific value field. What I would like to do, is to sort not just based on the value field - which it does via sort function - but also sort the members of the second break based on the footer's percentual value.

Fact is, I don't really need it to sort based on the value, but rather on its sub-total only. Sorting the value within each break is convenient, but not critical.

How can I achieve this?

Add comment
10|10000 characters needed characters exceeded

  • Former Member Jyothirmayee A

    I tried it, both yours and the version on the link, can't seem to get it working.

    I even aded a cumulative sum column, and applied the ranking to it with two breaks, nothing seems to work.

  • Former Member Former Member

    Solved the issue by: computing the 2nd-order break total percentage on each cell. Removed all breaks. Sorted by the mentioned field. Then re-added all the breaks.

  • Glad it worked!!! :)

    Thanks,

    Jothi

  • Get RSS Feed

0 Answers