Sorting Columns, mysql with rollup

garybrett37

Hi there, my tables are built on msql queries, I use 'with rollup' to add summary to all numeric columns which works great. Problem I now have is when sorting data it also includes the total field resulting in it always being at the top. If I sort single columns the summary appears all over the place..

Is there any way around this?

Thanks