Sorting allows you to display an ordered view of data.
To sort the display:
| 1. | Open your Analysis View. |
| 2. | Click ![ja-toolbar-changedatacube.png.9f1517dccf397f386c2c398257afc29e.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
| 3. | Click the Move to Rows icon ![ja-table-move-to-row.png.826115f8955848fc67c220af4e5e4c08.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
| 4. | Click next to Promotion Media and Product to remove them from the view. |
| 5. | Next to the Time filter, click the Move to Columns icon ![ja-table-move-to-column.png.b356dc6756143c53a1c731eff065e1b9.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
| 6. | Click Time to open a tree displaying the dimension members. |
| 7. | Expand Time by clicking ![ja-table-expand-red.png.b4976970f59a99c3bf6a0d9ae88cc950.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
| 8. | Click Measures in the column section, and deselect Unit Sales and Store Cost. |
| 9. | Click OK, then click OK again. |
| 10. | Click to activate Zoom on Drill. When active, its tool bar button looks like this ![ja-pro-zoom-on-drill-active.png.20b764f97434885002293d68f6e8f43d.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
| 11. | Click to zoom into USA. |
| 12. | Clear Zoom on Drill by clicking ![ja-pro-zoom-on-drill-active.png.c0a6319c183d4a961d094f161faa5ecd.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
| 13. | Click the navigation table’s Expand All Members button ![ja-table-expand-all.png.bcbaa1e41c63a12b79daaef3230703df.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
| 14. | Click the Edit Display Options button ![ja-pro-editdisplayoptions.png.0b58a86aa737f815ad70d179940ead80.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
| 15. | Click the navigation table’s Expand All Members button again. |
| 16. | Click the Sort button ![ja-table-sort.png.7e4ef41d4292e54797e53724e1e1759a.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
The navigation table displays the top stores for the year ordered by dollar sales amount.
![ja-ug-analysisview-foodmart-mondrian-westcoast-topstores.png.1dac94e170a56ef103da2de1dde6fda0.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
Sorting the Top West Coast Stores in Sales |
Open topic with navigation
Recommended Comments
There are no comments to display.