Looker have a very useful feature called Table Calcs which apply at the front end layer (not at the SQL layer). These allow for data calculations to be applied across, for example, Pivot Table columns (by referring to previous or next columns) and table (by referring to previous or next rows). The fact that the table calcs apply at the front end, mean they can only be applied on non-distinct aggregates but nevertheless they are really useful (and quick)!
Any plans for this sort of functionality in the future?