How to sort data in excel 2000?
 

"Maria" wrote in message
...
Hi,

I'm using excel 2000 and was wondering how I can sort the data in a pivot
table?
On the ROW side I have many different (and some identical) strings of
words.
In the DATA field I have put both the word strings to get the count of
them
as well as the value of each string of words.

I would like to sort the strings of words after; firstly the total count
of
word strings and secondly after the total value of the word string.

Bare in mind that it is Excel 2000 that I'm using so it doesn't work to
use
Data~sort to get it to work.... What am I doing wrong?


Thank you so much for the help with this!





"Bernard Liengme" wrote:

Your message is a little less than clear
Are you actually using a Pivot Table?
Why do you think Data | Sort does not work in XL2000?
What do your mean by "total value of the word string" ?
Maybe an example of 5-10 rows of data would help
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email




Yes, sorry I am not explaining this very well...

I have something like this:

Search String Value
Hello $114.95
help $17.90
thank you $27.90
thank you $87.90
thank you $87.90


I have made this into a pivot tabel by putting the search strings in ROW and
search string as well as value in DATA. This lookes somehing like:

Search String Data Total
Hello Count of Search String 1
Sum of Order Value 114.95
Help Count of Search String 1
Sum of Order Value 17.90
Thank you Count of Search String 3
Sum of Order Value 203.70

I want to sort this pivot table after the search string that is the most
common and therefore has the highest count of search string. And if there are
search strings that are equally as common then they should sort after value.

If I use Data~sort it will not sort after two different things.

Thanks!

How to sort data in excel 2000?
 

This seems to work in xl2003 ..

In your pivot as posted, drag "Data" field, drop it over "Total"
so that it looks like this (a single ROW cum 2 COLUMN layout):

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

Then select any cell under "Search String",
click the PivotTable dropdown choose Sort and Top 10
In the dialog, check "Descending",
using field: Count of Search String (select this option from the dropdown)
And .. that should yield the exact results that you're after

Yes? Punch it here, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Maria" wrote:
I have something like this:

Search String Value
Hello $114.95
help $17.90
thank you $27.90
thank you $87.90
thank you $87.90


I have made this into a pivot tabel by putting the search strings in ROW and
search string as well as value in DATA. This lookes somehing like:

Search String Data Total
Hello Count of Search String 1
Sum of Order Value 114.95
Help Count of Search String 1
Sum of Order Value 17.90
Thank you Count of Search String 3
Sum of Order Value 203.70

I want to sort this pivot table after the search string that is the most
common and therefore has the highest count of search string. And if there are
search strings that are equally as common then they should sort after value.

If I use Data~sort it will not sort after two different things.

How to sort data in excel 2000?
 

Dear Max,

What do you mean by PivotTable dropdown? The PivotTable I find has no "Sort"
option. Can it be because I'm using excel 2000?

Thank you!

"Max" wrote:

This seems to work in xl2003 ..

In your pivot as posted, drag "Data" field, drop it over "Total"
so that it looks like this (a single ROW cum 2 COLUMN layout):

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

Then select any cell under "Search String",
click the PivotTable dropdown choose Sort and Top 10
In the dialog, check "Descending",
using field: Count of Search String (select this option from the dropdown)
And .. that should yield the exact results that you're after

Yes? Punch it here, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Maria" wrote:
I have something like this:

Search String Value
Hello $114.95
help $17.90
thank you $27.90
thank you $87.90
thank you $87.90


I have made this into a pivot tabel by putting the search strings in ROW and
search string as well as value in DATA. This lookes somehing like:

Search String Data Total
Hello Count of Search String 1
Sum of Order Value 114.95
Help Count of Search String 1
Sum of Order Value 17.90
Thank you Count of Search String 3
Sum of Order Value 203.70

I want to sort this pivot table after the search string that is the most
common and therefore has the highest count of search string. And if there are
search strings that are equally as common then they should sort after value.

If I use Data~sort it will not sort after two different things.

How to sort data in excel 2000?
 

I don't have xl 2000. In xl2003, I'd click ViewToolbarsPivotTable to
display the toolbar. On that toolbar, there's a "PivotTable" dropdown button,
which drops a menu for selection, eg: PT wizard, Refresh data, ... etc.
Rummage around similarly in your xl2000, look around for the pivot's "Sort".
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Maria" wrote:
Dear Max,

What do you mean by PivotTable dropdown? The PivotTable I find has no "Sort"
option. Can it be because I'm using excel 2000?

Thank you!