ST Alpha - "Excel Help: let's say you have a Pivot Table. and within said Pviot you want to sort things in order from Highest to lowest" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 185

Excel Help: let's say you have a Pivot Table. and within said Pviot you want to sort things in order from Highest to lowest

Posted by Beaker (aka anniebecca) Sep 13 '11, 08:59

hypothetically how would one go about doing this?

Merci

Responses:

I've done a ton of Excel work and never had to use a Pivot Table. Why do you use one? - muzungu psilotum Sep 13, 09:00 10
- It allows you to slice and dice a large spreadsheet to get all kinds of information big and small - con_carne Sep 13, 09:08
- It allows you to analyze a huge data table by aggregating various columns and performing calculations with the intersecting data -- nm - Beryllium Sep 13, 09:04 4
  - Like, let's say you have a raw data table of all your company sales/invoices over the past 5 years ... you could use a pivot table to divide it by - Beryllium Sep 13, 09:06 3
    - Hmmm. I used to work with data sets too big for Excel. Not sure if that would have helped in this case, because you could not import the data. - muzungu psilotum Sep 13, 09:09 2
      - excel used to have a 65,000 row limit, that doesn't apply any more -- nm - Beryllium Sep 13, 09:10 1
        
        This was exactly my problem. - muzungu psilotum Sep 13, 09:11
- OMG, it is the single greatest tool within excel IMO. nm -- nm - groiny Sep 13, 09:01 3
  - and counterintuitively, GETPIVOTDATA() is the worst function in all of Excel. - TFox Sep 13, 09:05 1
    - agreed -- nm - decline Sep 13, 09:06
  - agreed. - Mel Profit Sep 13, 09:04
you should be able to right click inside of it, and select some grouping options. nm -- nm - groiny Sep 13, 09:00 4
- yep, right click-> sort (in excel 2007) -- nm - decline Sep 13, 09:01 3
  - sadly it won't let me sort it the way I need too :( - Beaker Sep 13, 09:25 2
    - highlight it all, right click and do paste special, and values. - groiny Sep 13, 09:27 1
      - winner winner chicken dinner! Awesome thanks -- nm - Beaker Sep 13, 09:30

Post a message top

Excel Help: let's say you have a Pivot Table. and within said Pviot you want to sort things in order from Highest to lowest

Replies are disabled on threads older than 7 days.