Display Top and Values Dynamically nested with other fields Top N Parameter by Nested With in Other Fields?

Display Top and Values Dynamically nested

Display Top and Values Dynamically nested with other fields Top N Parameter by Nested With in Other Fields?

1. Drag sales into columns.

2. Drag ship mode and Product Name into Rows. Then right click on the Product Name and select Sort option and select the fields as shown below.

Display Top and Values Dynamically nested

3. Now Create a Parameter for Top N Values. In that parameter window give the parameter name as Top N, and select the data type as Integer, and select the fields as shown below.

Display Top and Values Dynamically nested

4. Now create a calculation for the Top N Parameter, as shown below.

Display Top and Values Dynamically nested

In that select Default Table calculation, and select advanced options and give the fields like below.

Display Top and Values Dynamically nested

And then select OK. Then select the At the Level as Product Name and restarting every Ship Mode. As shown below.

Display Top and Values Dynamically nested

Leave a Reply

Your email address will not be published. Required fields are marked *