Lookup Data unrelated Table for Chart

[Danijel]

Hello all,

I'm trying to solve a problem that I'm stuck on after hours.

The problem is that I calculate a value X, for this value a value must be set from a second table (not connected). I can't connect the whole thing, because the reference has to happen dynamically on the surface for each filtering.

In the meantime I have tried the following:
- p()
- wildmatch
- if

But never with a really satisfying solution.

Maybe someone else has an idea?

Attached is an example file.

Thank you.

Greetings

[MayilVahanan]

Hi @Danijel 

Try like below

minstring(Aggr(if(sum(Value)=TValue,T%,'na'), T%, Dim))

[MayilVahanan]

o/p: