Sorting the Display
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.229cc35a16a06154d4610f70b27bb9d4.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
| 3. | Click the Move to Rows icon ![ja-table-move-to-row.png.b1d8adef7add60cb4f26a6123a0f664c.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.a03541489384797d8fa483b98fc5ecca.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.e07c72f40f7fc5c2fb6620a72ba30f03.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.9cfa312d71edd82c4c02f3528e49511e.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.9742ec63d87ec6766ba06ca6c880cf4b.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.0768f9c816cb9bb046fcb664e9c6602d.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
| 14. | Click the Edit Display Options button ![ja-pro-editdisplayoptions.png.38c0f9f5e6955608b6f9651e25ad34eb.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.ae1859d557c174e39a33ef6ef8a5bc73.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.35c72d0d961fe76876ac4823539ee6fd.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
Sorting the Top West Coast Stores in Sales |
Recommended Comments
There are no comments to display.