Grid Chart Heat Map

[#1]

I've been trying to create a heat map using QV's grid chart. I'm having difficulty sorting it as I'd like. I want the top left corner to be populated with the worse offenders and the bottom right corner with the best. That is, the column with the lowest total average is farthest left and the row with the lowest total average is at the very top. This forum keeps throwing me an error when i try to upload a sample QVW so I'm including here some additional info:

Chart Type: Grid Chart

2 Dimensions: "KPI" and "Project"

1 Expression: "Score" calculated with this expression ((1 -(sum(Score)/sum(WorstScore)))* 100)

[#2]

any thoughts on sorting a grid chart along both axes?

[johnw]

Sort both X and Y by sum(Z) descending. Substitute your own dimensions and expressions. See attached.