Forum Discussion
undefined
To show the top 5 customers by revenue for each branch in a matrix, you can follow these steps:
Add the Branch and Customer columns to the matrix.
Add the Revenue measure to the matrix.
Click on the Revenue measure in the Values pane and select "Value Field Settings."
In the "Value Field Settings" window, select the "Advanced" option.
In the "Advanced" window, select the "By Category" option.
In the "By Category" window, select the "Top" option and set the value to 5.
Select the "Branch" column in the matrix.
In the "Visualizations" pane, click on the "Format" button.
In the "Format" window, select the "Top N" option and set the value to 5.
This will show the top 5 customers by revenue for each branch in the matrix. The matrix will be sorted by revenue, with the top 5 customers for each branch displayed.