You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Sorting 2 data columns in Pivot Table

Sorting 2 data columns in Pivot Table

Price: FREE

I have a pivot table with 2 data (HI and LOW) for each row
I want to sort them descending on BOTH columns -when HI has the same value for 2 or more items, then sort them descending by LOW
So far I can only arrange them by HI
and keep getting a table like this:
Number Name HI LOW
1 A 900 900
2 B 900 850
3 C 900 880
4 D 800 700
5 E 800 750
So, I need that C should be above B
and E above D
I have try the Z-A button on HI and then LOW
and also clicking on Number->More sort options->Descending by HI
but can't make the pivot table do what I want

Visit publisher's web-site: Sorting 2 data columns in Pivot Table

Category and Tags: ExcelTutorials :

Related Tutorials

Pivot: Sorting from outside

Free: Yes
Tags: Excel ›

Another pivot question:
As a condition of my data source, I can't have a calculated field in my pivot table, so instead I have formulas outside my pivot table to figure things such as differences. I want to be able to sort by my formulas (amt of difference); how can I do this with a pivot table?
VBA or process, either solution would be a Godsend.

Sorting In Pivot Table,No Blank in Data

Free: Yes
Tags: Excel ›

Is it possible to add multilevel sorting in the Pivot table as in the case of the sheet.
Also how can I remove the word "Blank" in the Pivot table ,where there is no data in the sheet from where the pivot table is retrieving data.

Pivot table and sorting data

Free: Yes
Tags: Excel ›

I have attached spreadsheet of sample data. Basically I need to group the data by customer/supplier, so I have a total for each customer/supplier and then a way of maximizing the total so I can see the transactions that this consists of.
My problem is that I need a way of sorting the data firstly by customer/supplier name, and then from largest to smallest total sales/purchases.
I have come to the conclusion that a pivot table is the best option here but I can only seem to sort data by one column.

Pivot table sorting

Free: Yes
Tags: Excel ›

I have a pivot table.I want to sort the same on part code who have book qty is greater than 0 ( zero ).Is it possible?
Pl.look attach file for more clarification.

Summarizing Data with Pivot Table

Free: Yes
Tags: Excel ›

I have a small problem with pivot tables I want to group data per tags. For example I have a list showing the cities and the countries they are located. I want to see the grouping in different columns; please refer to attachment for further details.
Sorting does not work my special purpose. I am trying to create a dynamic table.
Any explanation on how you construct the pivot table will be

Related Applications & Scripts

Sort Tables Columns using JavaScript

Free: No
Tags: JavaScript › Excel Sorting Data

Implementing a table sort, allowing the ability to sort a table by a column, is a common task and the most implemented solution is to send a request to the server for a new page containing the sorted table. Dynamic Table is a javascript table sort tool which uses javascript to allow client side sorting of your data tables.
With Dynamic Table you can make any data table sortable with just one javascript include and one call to an initialization function. After the call the table will can be sorted by clicking on any of the table headers. Because Dynamic Table sorts at the client side it removes unneccessary load on the server and reduces bandwidth usage while at the same time providing near instantaneous response times for the user.
As an added bonus Dynamic Table also allows the user to hide/show the columns they want to see. This can be a real boon in tables with many columns where only a small subset of the data is required.

AJAX data listings engine

Free: Yes
Tags: PHP › Excel Ajax Table and Datagrids

The system is written in PHP and can be used to list data in any mySQL table, all you do is specify the mySQL database details and the engine will automatically generate a data listings table as per the configuration.
The system supports AJAX column sorting and page listings and offers a search facility. The engine generates both AJAX and non-JavaScript versions of the data listings so older web browsers will still be able to use the column sorting, page listing and search facilities.

Ajax Powered MySQL Table Viewer

Free: No
Tags: Ajax › Excel MySQL PHP

MyAjax is a MySQL Ajax Table viewer which allows for sorting, searching, and viewing of large amounts of MySQL table data in a quick and easy to use Ajax web interface. MyAjax features Ajax Sortable Columns, Ajax Search, and Ajax Paginated Results. Uses jQuery for Ajax calls and Javascript functions. Config file includes customisation variables to set which fields to display and their default sort order, which field to search on, results per page and more

Just Ajax Table

Free: No
Tags: Ajax › Excel PHP Table and Datagrids

JustAjaxTable performs all operation with tables "on-fly" using Ajax requests. It is an Ajax/PHP grid library that allows you to create web-based data grids/tables that behave like desktop software.
Features:
In-place cell editing, live scrolling, live sorting, PHP/MySQL backend, cross-browser support.

PHPMyEdit: display and edit mysql data

Free: Yes
Tags: PHP › Excel CRUD MySQL

phpMyEdit generates PHP code for displaying/editing MySQL tables in HTML. All you need to do is to write a simple calling program (a utility to do this is included). It includes a huge set of table manipulation functions (record addition, change, view, copy, and removal), table sorting, filtering, table lookups, and more.

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing