Hello all. I have a chart that has 3 dimensions for the rows of the chart. I've chosen a reasonable ordering of these dimensions so that the chart conveys the best experience, but there are legitimate reasons why a different ordering would convey information better, depending on what the user is trying to learn from the chart. I'd like the user to be able to change the order of the dimensions themselves. Probably through a drop-down list or pre-chosen sort orders, to make it simpler. Best ways to do this? Thanks!
If there are only three dimensions involved, I would create individual sheets and use a parameter to swap the sheets.