I'm using the powerKPIMatrixEB and it does everything I need with comparisons to targets and sparkline trends - I'm having trouble trying to get it to sort on a column other than what's been put into Metric Name. At the moment I have the name of sales person in the Metric Name and their sales amount in Current Value.
At the moment it's sorted (alphabetically) by the name of sales person and I'm wanting to order it so that it's able to be sorted by their sale amount. Am I missing something somewhere that I can set which column it gets sorted by? I've tried the "Sort Order" on the Fields tab but that doesn't seem to do anything.