The following are the steps:
- Within the workbook associated with this chapter, navigate to the worksheet entitled Pareto - Basic and select the Bank data source.
- In the Data pane, change Account # to a dimension.
- Place Account # on the Columns shelf and Current Loan Balance on the Rows shelf.
- Click on the Fit drop-down menu and choose Entire View.
- Right-click on the Account # pill and select Sort. Set the sort to Descending by the aggregated sum of the field Current Loan Balance.
- Right-click on SUM(Current Loan Balance) located on the Rows shelf and select Add Table Calculation. Choose the settings as shown in the following screenshot:
- Drag an instance of Account # to the Detail shelf. ...