Re: Total as last row

[Peter Brawley]

> no one else has figured this out either.

?! First, Rollup cannot make Group By "not work". Second, you have complete control over whether and how you display Rollup rows, eg ...

select
  if(a is null and b is null, ..., ... ) ...
  ...etc...
from
  select a,b,c,sum(this),sum(that)...
  from ...
  group by ... with rollup
) sums ;