Skip to Content
Former Member
Dec 10, 2008 at 09:45 AM

Use Ranked List values



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.

Many thanks

/Philip Barbar