As always, thanks for your support and efectiveness!
I tried your solution, and it worked but with a limit, as you can see in my output, the formula works only for one period, but it doesn't work for all my periods:
Could you help me to extend this results to all the periods??
Thanks in advance!
Can you try this:
=If(ColumnNo() > 1 and Only(Value) = 0, Before(Column(1)), Only(Value))
Where the 1 in Column(1) is the determined by expression number in your chart object.
In the sample there was only one expression and hence I used Column(1). But if this was 2nd expression, I would have used Column(2).
I hope that this make sense?
Community_206643.qvw 152.5 K