Can someone tell me how I sort this table using the total column and in descending value?
Thank you, it's driving me crazy.
Pivot Table001.jpg
Can someone tell me how I sort this table using the total column and in descending value?
Thank you, it's driving me crazy.
Pivot Table001.jpg
clikc on column Total
choose sort => decending
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
If I selectt just the total column I get this:
Pivot Table003.jpg
If I select the whole table the sort option goes away.
You have to click in the column Total
Not select column E (in your example).
Hmm. I did that, the sheet flickers like it does when it sorts and then nothing has moved.
I'm very challenged with this Excel thing, thank you for helping.
I need it to look like this:
Pivot Table004.jpg
Post your file (of course, without confidentional information), so we can work in it.
It's 12 megs
I tried 7zip but gives me an error when I upload.
Can I email it somewhere?
just a small example (with the same format) will do.
just post it on this forum (not mail).
The smallest I can get it is 6 mg. and that like 15 rows of data.I must be doing something wrong.
I will keep trying.
Thank you for your help and patience.
kellie
Paste just 15 row in another workbook and make an pivot table of that.
I hope this is enough.
Excel 2007 =>
I used options for pivot table (at the end of the lint).
then i used sort A-Z or Z-A (count of column 10).
doing that i'm in column E (in the table).
Then I get the result as shown in the attached file.
Okay I finally got it! Geez am I blonde or what?! (in fact I am! Ha!)
Thank you for helping me.
Kellie
Thanks for the reply.
Glad I could help you.
That's why i asked for an workbook with data.
So I can show you.
If your question is solved, will you mark it as solved?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks