Using one field as key dimension and but show values from other field

[wiz_nerd]

I am using ID field as dimension but I want to

show the value of Version.

 I want all the results except null values.

ID	Version	x	y
1	abc_12	1	1
2		2	2
3	abc_14	3	3
4	abc_15	4	4
5	abc_16	5	5
6		6	6
7	abc_18	7	7
8	abc_19	8	8
9	abc_20	9	9

Version as dimension based on ID Desired table

Version	x	y
abc_12	1	1
abc_14	3	3
abc_15	4	4
abc_16	5	5
abc_18	7	7
abc_19	8	8
abc_20	9	9

[lorenzoconforti]

Not sure I understand 100% what you are trying to achieve but possibly you could use this an expression? 

Only(Version)

What is your desired final table?

[wiz_nerd]

Hi Lorenzo,

Please check I have updated the desired table.

[lorenzoconforti]

Why are you not using Version as dimension?

[wiz_nerd]

Because IDs are sort able and version is not.

[uacg0009]

Hi,
If you create a table box, and put "Version", "x" and "y" column into this table box,
is that what you want?
Aiolos Zhao

[lorenzoconforti]

Just sort Version by ID