I have a table with two columns a and b. I manually enter data into a cell in column a, and I want the corresponding cell in column b automatically show a value caluclated from my input in a.
E.g. a is a number and b = 2 * a. In Excel I can define this behavior easily. In SPSS I only know how to do this manually (by Transform > Compute ...), but that way the cell only shows the computed value, after I manually call this function.
How can I set up column b to compute automatically, upon input?