Use the Rank function and then filter the top 10
Steps:Use the function Rank to obtain the ranking for each data item.
The rank column has this calculation: Rank([Revenue] for [Product line])
And then add a filter to the report: Rank <= 10
In the filter definition, set the application to After auto aggregation.
You will get the top 10 revenue generated by product line based on the sales Rep.
No comments:
Post a Comment