How do I sort data in PivotTables in Excel 2000?

[Maria]

Thanks for great help!

There is only one thing that I still can't get to work.

My pivotTable now looks like this:

Data
Search String Count of Search String Sum of Value
Hello 1 114.95
help 1 17.9
thank you 3 203.7
Grand Total 5 336.55

I'm able to sort the data by "count of search string" by right-clicking on
search string ~ field settings ~ advanced ~ and there use the auto sort
function. But How can I sort the table by sum of value if the count of search
string is the same? I would like it to sort by count of search string AND
THEN by sum of value. Is this possible in excel 2000?

Thanks again!

 

[Max]

.. I would like it to sort by count of search string AND
THEN by sum of value. Is this possible in excel 2000?

Within the live pivot itself, I don't think so. Even in my xl2003 there's no
such feature that I could gather. You would need to make a frozen copy of the
pivot, then proceed via Data > Sort.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---