hi,

That did the trick.

I just removed the total field from the "Row field" and kept only sum of
total (data).

With both the data in place sorting is not possible.

thanks all

Regards,

Jimmy Joseph

On 11 May 2006, you wrote in microsoft.public.excel:

> Select a cell in the Total column, then click the Sort Descending
> button (Z-A) on the Excel toolbar.