I am trying to sort some data in a hierarchy that I have built. What I would like to do is be able to sort the data at different levels of the hierarchy.
Currently, I can sort the data at the level hierarchy. I want to keep this functionality. However, I also want to be able to sort the data at the label level.
For example, right now if I try to sort sales at the label level, it only sorts based on what level it is at. I want to be able to sort data descending or ascending regardless of what level the data is at.
I have attached the workbook to provide better context