rank function for fixed row

[#1]

Hi everybody.

I need to build a chart, which returns the rank of fixed ID, where the current selection is taken into account.

In this example the chart (highlighted in red) musst display the value "3".

When I kick out ID 2 from the current selection the rank musst change to "2",

as ID 4 becomes the second lowest value of the selection.

thank you for your help

best wishes.

[Anil_Babu_Samineni]

Can you post sample application?

[ecolomer]

See this example

[ecolomer]

And this one

[#5]

Thank you for your help, unfortunately I'm working with a student license, so I can't upload a sample.

I want the chart to display only values for ID=vSet_ID (4 in this case)

(ID, KPI, rank)

The chart is a straight table, with no dimensions.

The expressions are shown in the picture.

The set expressions: min({1<ID = {4}>}ID) works for the columns ID and KPI, but not for the rank expression.

I hope I could make the problem clear.