max()

Example - Find the Largest Opportunity for Each Account

1q = load "Ops";
2q = group q by 'Account_Name';
3q = foreach q generate 'Company' as 'Company', max('Amount') as 'Largest Deal';

Example - Find the Last Value in List of Airline Destinations per Origin

For dimensions, max() sorts the values alphabetically and the last value is returned.

1q = load "Airlines";
2q = group q by 'origin';
3q = foreach q generate 'origin' as 'Origin', max('dest') as 'Max Destination';