RANK on Total & Sort Nested Dimension
Hey builders, I'm trying to match a mockup, but having trouble building it in Anaplan.
I need to rank all projects by their total cost (highest to lowest) while showing the breakdown of Project Total Cost by each Cost Pool (if there is a value in a cost pool).
Rows: Projects and Cost Pool
My filter for hiding Cost Pools with value - 0 is working correctly. I've been playing around with RANK function but cannot figure out how to rank by Project Total or by All Cost Pools sum. Even with trying to sort, I get the error "Cannot sort a nested axis - sorting an axis with nested dimensions is not supported."
What would be the closest solution to build this out to match the task?
Thanks in advance!