The ability to have additional columns populated based on common logical expressions (IF, COUNT, LOOKUP etc)
The example I have is as follows:
I have a collection of products which belong to a single category. When I display a list of products I want the product image to be displayed. If there is no image, I want the category image to be displayed.