Yup matrix seems like the best choice 🙂 thanks a lot for the solution.
I had a question relating to the automatic sorting (higher number on the bottom left). Is there a way I can do this? I tried the ellipsis -> sort by. But this only rearranges rows but not columns (higher values on the bottom). How can I move these to values to bottom left? (prefer if I can avoid the rankx function)
E.g. Automatically Move columns 3 and 6 to rows 1 and 2, even when I drilldown.
Sort each row - row 2 highest value is 285 but it is not at the bottom.