I have a pivot table with two dimension columns (state and city) and several expression columns (revenue, units, revenue-per-unit). I want a new column that shows the highest revenue-per-unit of any city in each state, on all the city records. (i.e., the same value for all cities in each state) It seems I should be able to use 'rangemax' and 'before', but I can't figure it out.
Thanks
