# Sorting OLAP Data

Develop powerful and lightweight web applications using ASP.NET MVC controls. Learn more about the ComponentOne MVC controls in ASP.NET MVC documentation.

## Content



By default, results in the OLAP output table are sorted by key, for example, "Argentina", "Brazil", and so on. This is not always the most useful way to show the data. To allow this, set the AllowSorting property on PivotGrid to **True** (default). It allow the users to sort the data by clicking on the column headers, just like a regular grid. Clicking the header repeatedly changes the sort orders from ascending to descending to unsorted.<br /><br />![](https://cdn.mescius.io/document-site-files/images/2b3ac322-100e-4637-958d-fb40dcda3f44/images/olapsorting.png)