Is there a way to use the values of the ranked list values in order to use them in a key figure in the same query?
The problem is that I have four columns with actual values, which I then choose to display as Ranked Lists. Then I would like to sum up each ranking value from the four columns and display / rank the summed values in like a "Total Score".
I have a key figure that is a summation of the values of the four columns, the problem is that it is taking the underlying values, instead I want to sum up the values of the ranking values.
Is there a way to achieve this or is there any other solution?
All help is appreciated.