Ranking Dimension by multiple measures

[msanchez]

Hi,  I have an unusual chart to build and I'm struggling to build it as the user is asking.  

To simplify I have 1 dimension and 4 measures

	Measure1	Measure2	Measure3	Measure4
Dim1	1	2	3	4
Dim2	2	3	4	5
Dim3	3	4	5	6
Dim4	4	5	6	1
Dim5	5	6	1	2
Dim6	6	1	2	3

They want it displayed with a rank on the left and the dimensions sorted by the value of each measure but displaying the dimension name.

1	Dim1	Dim6	Dim5	Dim4
2	Dim2	Dim1	Dim6	Dim5
3	Dim3	Dim2	Dim1	Dim6
4	Dim4	Dim3	Dim2	Dim1
5	Dim5	Dim4	Dim3	Dim2