Sorting in Excel 2000 Pivot Tables

L

LPS

In an Excel 200 Pivot Table I have a column of text data which appears as
follows: P1-10, P1-2, P1-20, P1-5.

Is there anyway I can re-sort this data so that it appears as follows:
P1-2, P1-5, P1-10, P1-20.

Thx,
 
D

Dave Peterson

How about change the underlying data to look more like:

p1-02
p1-05
p1-10
p1-20

Then your sorting will become much easier.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

QUESTION: How can I conditionally compute data in a pivot tables? 1
Generate Pricelist from Product list in Excel 2003 0
how to add a special subtotal in the pivot table? 0
Group by month 2
Conditional Formatting Pivot Table Rows in Excel 2007 9
Sorting Multiple Tables 1
AVERAGE IF with multiple conditions 6
Applying Percentages to a Pivot Table 0

Top