How to display the last 3 values in a column horizontally

[pturmel]

@Brennan_Joles

Honestly it seems ridiculous that vision doesn't have the option to transpose rows and columns easily or even pull multiple rows into a string.

Well, Vision may not have script transforms built into the binding window, but you can get the effect of that by using runScript() or my objectScript() in an expression binding. Such a script can perform whatever transpose operation you like. This solution predates Perspective:

Transpose Rows and Columns

I have something that could be massaged into what you need. The follow code is designed to take one or more datasets, each with a just a few rows, and flip all the rows into columns. Should be close to what you need: #---------- # Construct a dataset with columns from supplied datasets rows. The column # names from the first dataset become the string values in the first column # of the result. The first argument to the function is a sequence of names # for the dataset arguments. The name s…

You might also find the Pseudo-SQL PIVOT from my view() expression function useful.

{ objectScript() and view() are from my free Simulation Aids Module. }