Last Modified Date: 12 Feb 2018
AnswerUsing the attached sample workbook, which makes use of the Sample - Superstore, follow these steps:
- Drag "Manufacturer "to the Rows shelf.
- Drag "Sales" to the Columns shelf.
- In the Data pane, click the drop down to the right of Dimensions and select Create Parameter.
- Name the Parameter (in this case "Top N").
- To the right of Allowable values:, in the Create Parameter window, select Range.
- Under Range of values, specify the Minimum, Maximum, and Step size desired.
- Click OK.
- Right click on "Manufacturer" in the Rows shelf and select Edit Filter.
- Navigate to the Top tab in the Filter window.
- Select By field:
- In the second drop down field to the left of "by", select "Top N"
- Ensure that the field to filter by (usually a measure) is specified, in case "Sales" as "Sum".
- Click OK.
- In the Data pane, under Parameters, right click on "Top N" and select Show Parameter Control.
- In the upper right corner of the view, there is now a "Top N" slider and number field. Changing this field by moving the slider, will change what is shown in the view.
- Lastly, in the toolbar at the top of the screen, click on the Descending button icon, which will sort SUM(Sales).
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials