--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire
Hi,

I'm confused - Sum of word strings would all be 0, what are you really doing
here?

Second - the data is automaticlly sorted on the contents of the Row area
regardless of where you have a sum or a count in the data area - so why do
you want to sort the "rows"?

If you want to sort on the value area (data area) then the technique is
different depending on whether you are in 2003 or 2007, which one are you in?


"Maria" wrote:

I have a Pivot table with different word strings on the Row section and both
sum of Data and Count of word strings in the Data section and I can't figure
out how to sort the Rows after firstly Count of wordstrings and secondly sum
of the data. HOw can I do that?

Thank you so much for all help!