Thanks, Rob! That worked great! What if I also wanted to add another
expression the straight table to get the the maximum by day (i.e.
WeekDayName= 'Sat') Can I add another field to the sort or do I have to
add it as a set analysis within that formula you wrote?
=FirstSortedValue(DISTINCT NetSales, -aggr(sum(NetSales), SalesDate,
On Thu, May 31, 2012 at 4:28 PM, Rob Wunderlich <