Sorting Data in the Pivot Grid Fluid View
You can sort data in three ways in the Pivot Grid fluid view:
Detailed View.
Facets or filters.
Chart.
This table summarizes the sorting features and their exceptions:
Feature |
View Mode |
Available |
Exception |
---|---|---|---|
Sorting in Detailed View |
Fluid |
Yes |
Sorting of formatted fields is not available. |
Sorting in facets or filters |
Fluid |
Yes |
Sorting of facets with tree values is not available. |
Sorting in chart |
Fluid |
Yes |
None |
In addition to sorting the string data type in the Detailed View, you can sort data for all the fields which are assigned different field types, such as numbers, dates, and so on.
In the fluid view, you can specify the type (number, date, and so on) of fields at runtime and then perform the sorting.
Note: Sorting is not available for formatted fields Currency/Number and Date/Date Time.
In addition to sorting the string data type in facets and filters, you can also sort data for all fields that are set with different data types, such as numbers, dates, and so on.
Note: Sorting is available for all data types in facets and filters, including sorting for the formatted fields that are set to Currency/Number and Date/Date Time. However, sorting for tree values in facets and filters is not available.
Sort these values in the Pivot Grid charts:
X-axis values.
Series values.
Facts.
Select the Sort Options link to open the Sort Options dialog box.
Note: Sort Options is disabled for Pivot Grid Only and Pivot Grid and Chart views.
Field or Control |
Definition |
---|---|
Sort Field |
Select the Data Source Column to sort. |
Sort By |
Select the Data Source Column which will be referred to while sorting the Sort Field. |
Order |
Select descending, ascending or by default order of sorting. |