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 |
