I understand why I can't sort using the value that is nested (Bin Location/Bin Number/Bin On Hand in this example), but I feel like I should be able to sort on any of the other values to the left. I can sort by the first column (Item Number), the entire line is sorted based on that value. Why can't I do the same for any of the other 2 values and have the table rearrange by banded row? In this workbook, it would essentially rearrange by banded row color.
I've added a column to the front of your table and hidden it. To sort descending you can make the Sort field negative, and to switch between ascending and descending, you'd need another parameter that you could multiply the Sort value by (you could make an integer list of 2 values, -1 and +1 and display them as descending and ascending).
