Select most left value in Pivot

[Pericator]

Hello,

ist there a way to get the most left value, which is not null, per row in a pivot table? See attached image for example.

Thanks in Advance

[materi]

What about a left-join?

https://www.dofactory.com/sql/left-outer-join

[Pericator]

I only got one Table, I dont want to join some other. I want a function on visualization level, which allows me to calculate some other values. And therefore I need the first value in each row. 

[Pericator · Accepted solution]

I found a solution:

Total <Date Dimension>