topic Re: Select most left value in Pivot in App Development

Select most left value in Pivot

Pericator — Tue, 25 Jun 2019 09:50:38 GMT

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

Re: Select most left value in Pivot

materi — Tue, 25 Jun 2019 10:17:30 GMT

What about a left-join?

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

Re: Select most left value in Pivot

Pericator — Tue, 25 Jun 2019 10:19:36 GMT

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.

Re: Select most left value in Pivot

Pericator — Tue, 25 Jun 2019 10:35:22 GMT

I found a solution:

Total <Date Dimension>