Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @Danijel
Try like below
minstring(Aggr(if(sum(Value)=TValue,T%,'na'), T%, Dim))
o/p: