Swapping and Conditionally Formatting Metrics in a Table

[@matthewrisley9070]

Another great tip, Andy! I love learning from you.

[@francisjohn256]

Great tip Andy

[@rohithreddysureddy9151]

E: Useful Tip..

[@charliehutcheson1185]

Do you think this can be combined with a Top N filter of some sort Andy? I'm trying to allow users to Pick a Metric to sort their data by, so Top N by Sales, or Top N by Profit, or Top N by quantity in Superstore terms.

[@charliehutcheson1185]

Actually - figured it out. Used a parameter to select top N customers and compared INDEX() to that to control output.

[@RJYL]

I like it. Thanks.

[@adolfohc78]

How can we sort the 'Pick a Metric' field. I've been 2hrs trying to do it with no success :-(

[@vizwiz]

Edit the parameter and drag them up and down.