How to do top 10 sales – product chart.
13 May, 2011
Hi,
Could you show me how to do top 10 sales - product chart.
I know how to do the listing of the rank but I need to cut the first 10 product.
Only top 10 products to be displayed not the 11th and the rest.
Thanks
Could you show me how to do top 10 sales - product chart.
I know how to do the listing of the rank but I need to cut the first 10 product.
Only top 10 products to be displayed not the 11th and the rest.
Thanks
Hi,
You can use the analytic function 'Top 10 Rank' to show only the top 10.
Alternatively, you can use the 'Top N Rank' to specify the amount of results on the list.
Please let me know if this doens't give you the results you were after.
Regards,
David
You can use the analytic function 'Top 10 Rank' to show only the top 10.
Alternatively, you can use the 'Top N Rank' to specify the amount of results on the list.
Please let me know if this doens't give you the results you were after.
Regards,
David