| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort by data in most recent month
I have a pivot table with my Items in the rows, months in the colums, and my
data is sum of sales. I want to sort by the most recent month. I changed the sort from using the items to using the Sum of Sales and it re-sorts but I have no idea what month it is using to sort? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort by data in most recent month
Hi,
Just put your cursor in the data area for the most recent month and click the Ascending or Descending sort button. -- Cheers, Shane Devenshire "Jenzz22" wrote: I have a pivot table with my Items in the rows, months in the colums, and my data is sum of sales. I want to sort by the most recent month. I changed the sort from using the items to using the Sum of Sales and it re-sorts but I have no idea what month it is using to sort? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort by data in most recent month
Ha, that was way too easy! Thank you!
"ShaneDevenshire" wrote: Hi, Just put your cursor in the data area for the most recent month and click the Ascending or Descending sort button. -- Cheers, Shane Devenshire "Jenzz22" wrote: I have a pivot table with my Items in the rows, months in the colums, and my data is sum of sales. I want to sort by the most recent month. I changed the sort from using the items to using the Sum of Sales and it re-sorts but I have no idea what month it is using to sort? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you sort the data by the month of the data? | New Users to Excel | |||
| How do you sort the data by the month of the date? | New Users to Excel | |||
| Finding the most recent month's (or whatever) data | Excel Discussion (Misc queries) | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| How do I sort data by Month on the date format like (02/04/97)? | Excel Discussion (Misc queries) | |||
Linear Mode
