How to get column in a table depending on the selections of a list box?
Hello all
I need to calculate a table, and one column depends on the selection of a list of values that are summarized as a new column; the values that are not selected, should be visualized as extra columns at the same level:
My data:
Runner
Act
times
Runner1
1km
1
Runner1
5km
2
Runner2
20km
2
Runner3
5km
1
Runner3
1km
3
Runner2
5km
2
Runner2
3km
3
Runner1
3km
2
The field tha the end user uses todefine the field "Long distance"
Long distance
1km
5km
20km
The resulting table, when end user selects in "long distance" field the value 5km and 20 km