Pivot Table Sorting

  • Thread starter Thread starter Sort in Pivot table
  • Start date Start date
S

Sort in Pivot table

Hi everyone,

I have a pretty big pivot table that I want to
sort per values in the columns and I have tried several
times to sort with the function sort in the pivot table
menu but it never seems right and I can't get the sorting
I need. Like if I had a list of company names (in the ROW
section of my pivot) with their total stock value (in the
DATA section)and I would have like the currency in the ROW
section. Now if I would want to sort my pivot table in a
descending order for the US dollar value in my table, what
would I do ???
 
To sort on a data field, put the cursor on one of the enties in the Row area
(Company Name), right click, choose Field Settings, choose Advanced, choose
Ascending, and then choose the Data item you would like to sort (i.e. USD
value).

Good luck

Frank
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to Group in Pivot Table 1
Pivot table drill down sort 0
Expand and collapse 2
Excel 2010 Pivot Table 2
Sort calculated field in a pivot table - an example 1
Sort Pivot Table by Gran total automaticaly 2
How I can set dynamic pivot table ONLY when I have enough data point 1
Retaining the order of Data while using Pivot table 9

Back
Top