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.
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.
4. Now create a calculation for the Top N Parameter, as shown below.
In that select Default Table calculation, and select advanced options and give the fields like below.
And then select OK. Then select the At the Level as Product Name and restarting every Ship Mode. As shown below.