Excel Statistics 03: Data Analysis Sorting & Pivot Tables

[Jaderoccs]

Is there a way to sort pivot tables by date. For example I want the pivot table to automatically sort / display from July 2010 to June of 2011. I'd like to learn the trick to not manipulate the cells once the PT is complete, but for all pivot tables

[roses999us]

thank you so much! since I couldn't find a better way to do it, I just simply changed the single digit number to double digits such as 832 Washington 01, 10, 11, 02, 22, that way it turned out to be 832 Washington 01, 02, 10, 11, 22 instead of 1, 10, 11, 2, 22..

[roses999us]

would you please tell me how to sort this data? Excel turns out: 832 Washington A 832 Washington 1 832 Washington 10 832 Washington 11 832 Washington 2 832 Washington 22 but I want: 832 Washington A 832 Washington 1 832 Washington 2 832 Washington 10 832 Washington 11 832 Washington 22 Thank you!

[ExcelIsFun]

Most programs use ASCII characters. There are 255 ASCII characters. Sort is based on these. I will send you an e-mail with more detail.

[BurnKilluminati]

Hey if the data in the column you have highlighted changes when you click sort, but the other columns do not change, does that mean that the data in other columns is incompatible with the original data selected, or does it only mean that sorting will only change data in the columns that are highlighted?

[ExcelIsFun]

I do not understand what you are asking.

But, if the data set has field names (column headers with different formatting) at the top, and records in rows and no fully blanks columns or rows, then click just one cell in the column that you want to sort and then click the sort button.

Did that help/

[veracabasal]

sir what is your website? i want to download your files too..

[ExcelIsFun]

search for:

excelisfun

Then go to the YouTube channel and watch the video that automatically plays - it shows it all.

[sublimeisdope]

hahaha 7:51 "i guess it does"

[sublimeisdope]

hey this is saving me big time thankyou! one thing though, i found it hard to reach part three, i could only fine it through the into link!

[ExcelIsFun]

Did you finally get to part 3?

I hope so...

[ncbookz]

i have to admit he is probably a better teacher than i am good job

[ExcelIsFun]

Just different.

I am glad that you liked the video.

[Sincerelust]

This is what I really needed. You're awesome.

[ExcelIsFun]

I am glad that it helped!

[a386462479]

Thank you so much, I learn a lot from your videos.

[ExcelIsFun]

You are welcome!!

[marmon4270]

Awesome.  Great explanation of pivot tables.

[ExcelIsFun]

Dear marmon4270,

I am glad that videos work for you!

--excelisfun

[buji81]

Just SUPERB!...Thank You for this!

[ExcelIsFun]

Dear buji81,

You are welcome!! I'll keeping making the videos if you keep watching and rating!

--ExcelIsFun