All Questions
Tagged with sorting pivot-table
13
questions
0
votes
1
answer
112
views
How to create a sorted table summary of the count of a categorical column in Excel?
I have a dataset like:
Animal fruit
cat apple
dog grape
cat cherry
cat pear
dog cherry
horse melon
cat lemon
I would like to create a summary table counting each occurance ...
0
votes
0
answers
3k
views
In an Excel PivotTable, how can I sort by multiple row fields?
In Excel PivotTables, it's easy to sort, say, the rows by the major row field: There's a "Row Labels" column with a menubutton on the side, you click it, and you get sort options, just like ...
1
vote
1
answer
5k
views
Pivot Table: Sort row by hidden field
I have a table in Excel 2016 (source: Microsoft Query/ODBC):
Raw data:
Construction Type Location Sort
Reconstruction Main St - Red St to Blue St 1
...
3
votes
1
answer
13k
views
Excel pivot table sort by values
I've done quite a bit of searching but cant find working instructions on how to sort a pivot table in Excel by a field that has been placed in the Values area.
The best I've been able to come up ...
0
votes
1
answer
284
views
Excel Calculate Date Differences between Orders Per Customer
I have a data-set with Account Names, Order IDs and Close Dates. I would like to see the number of days between orders, per customer, however Excel will not allow me to sort by date in my Pivot Table ...
-1
votes
1
answer
2k
views
Making the filter pane in pivot table sorted
Pivot table filtering panes lose their sort order when data is appended to the table which is linked to the pivot table.
At first, the sort order in the filtering pane looks nice:
But if you haven'...
0
votes
2
answers
13k
views
Pivot table filter pane is not sorted. Why?
In my pivot table filter, the column containing numeric values is not sorted, while the corresponding column in my data table is nicely sorted. Why?
Data:
Original pivot:
I recreated the same table ...
6
votes
2
answers
46k
views
Not able to sort columns
I have a pivot table and I would like to sort some columns. But the "sort" function is not working at all. When I click "sort from A to Z" nothing happens. I am just able to sort the first column of ...
0
votes
1
answer
2k
views
How to Sort a Pivot Table based on two columns of information
I work in the Auto Industry where I have to create a Pivot Table based on Auto information each month. The Sort Order of the Pivot Table needs to be
Model Series
Door
Cylinder
Model ID Code
Trim ...
1
vote
3
answers
14k
views
Sort Excel Pivot Table by Percentage of Count
I have source data showing timesheet approvals in the following format (for about 850 employees and 200 managers):
Employee Name Manager Name TS Approved?
Employee 1 Manager 1 No
...
4
votes
1
answer
52k
views
Cannot sort Excel Pivot Table by two or more columns
I want to sort my Pivot Table by two columns. I've searched the web for some time, and it seems Excel doesn't allow this, so I need a workaround.
My data
Desired Outcome
I want to summarise this by ...
2
votes
1
answer
9k
views
Pivot table : absolute value of grand total in Excel
My grant total is generated by summing values of COLUMNS of ITEMS for a given SUBJECT (For each SUBJECT I have a list of ITEMS and I want to make a grand total of the values of these ITEMS). The ...
1
vote
0
answers
360
views
Sorting in Pivot Table on how data is summarized, not just the value
Often I am creating pivot tables that summarize some count by some category. Let's say I am counting Yes/No responses by some category. I usually add the count field and display it as a "% of row", ...