Hi,
I would like to sort my pivot table by numerical order and not sure how to go about it. When I sort A to Z it breaks up the consecutive number order. Any suggestions? Thanks!
Pivot table and data attached below.
Pierre
Hi,
I would like to sort my pivot table by numerical order and not sure how to go about it. When I sort A to Z it breaks up the consecutive number order. Any suggestions? Thanks!
Pivot table and data attached below.
Pierre
That's because the underlying data (Column C) is text
Do this..
-In a separate cell input 1
- Copy this cell
- Select range in Column C
- paste special -- values -- Multiply -- Ok
Now,
- refresh the pivot table
- Sort A to Z
Does this work for you?
Life's a spreadsheet, Excel!
Say thanks, Click *
Actually, let me clarify actually. What I need is it to sort as if the first 4 digits are the year and the last 1-2 digits are the week number and needs to be sorted sequentially. So perhaps this isn't the best way to represent month and week number. Can you think of a way to do this using the week number column and the year column. Maybe concatenate as "2012 8" of "8 2012"?
Aah I see
In that case in Cell C2 use
=IFERROR((B2&TEXT(A2,"00"))*1,"")
Copy down
Your pivot table and sorting should now work well
thank you!!!
It isn't at all clear what you are trying to accomplish but already having a column for the Year and another for the Week number, why combine them?
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks