How to sort account dimension in FR?
How to sort account dimension in FR from the highest (parent account) to the lowest (base member account) as in hiearchy on Dimension? I wanna sort my FR's account column based on the COA Hierarchy (from Parent account to base member account) in dimension. But, FR standard sort the account from base member to parent account even I chose descendants function on the setup, but that's not work.
I want to make the FR like this:
But it turn out below from the lowest level account to parent level account in dimension in dimension, when I chose descendant setup.