Expand rows positionally up instead of down in matrix

[KSmithson]

I have a matrix for financial statements that looks like this:

Is there a way to make it so that the top level of the heirarchy (revenue, expenses, other) shows at the bottom and when expanded the next layer is above like it would be in an excel format? (see below)

This way the detail from the lower levels of the heirarchy add up going down to the subtotal and totals instead. 

Alternatively, I tried to put subtotals at the bottom, but there is no way to customize the name of each subtotal. They would just all say "total" or "subtotal" and not "total revenue" or "total expenses" 

[LagardR]

I am looking as well a solution to this topic.

[aj1973]

Hi @KSmithson 

You might need to add a column with numbers according to the order you want to see.

like : IF RPA Revnue then 1 ELSE

        IF REC Revenue then 2 ELSE

        .... 

[KSmithson]

I have the sort in the order I want them to appear already. The issue is I need the format to show the higher level of the hierarchy to show on the bottom, not the top.