Lesson: Sorting Data

  To sort the query:

1. From the navigation panel, select the Data Sorting icon.

2. Double-click on (double click to create a new sort rule).

   The selection defaults to Qtr1, Actual. The sort order defaults to Ascending in the Ordering list box.

3. Click Ascending.

   A down arrow is displayed next to Ascending.

4. Click the down arrow next to Ascending.

   Descending is displayed below Ascending in the properties panel.

5. In Ordering, select Descending.

6. Double-click on (double click to create a new sort rule).

   A data sorting rule is added. The selection defaults to Qtr1, Actual.

7. Click the down arrow next to Qtr1, Actual and select Qtr1, Budget.

   Observe that the order defaults to Ascending.

8. In the navigation panel, under Data Sorting, select Ascending, Qtr1, Budget, right-click, and select Delete Sorting Rule.

   The Ascending, Qtr1, Budget sorting rule is deleted from the query.

9. In the navigation panel, select Data Sorting, right-click, and select Apply Query.

   Essbase returns the results sorted in descending order for each quarter:

   

10. To close the worksheet, select File, and then Close.

    Do not save the worksheet.