# TopN/Rank calc? **URL:** \ **Category:** Product Ideas\ **Created:** [June 24, 2021, 6:41pm UTC](https://pug.phocassoftware.com/t/topn-rank-calc/1909 "2021-06-24T18:41:43Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Mike](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Mike](https://pug.phocassoftware.com/u/Mike)\ **Post date:** [June 24, 2021, 6:41pm UTC](https://pug.phocassoftware.com/t/topn-rank-calc/1909/1 "2021-06-24T18:41:43Z")
Hi PUG, I’m looking for a way to dynamically filter for top customers for each of my stores. Ultimately, I want to provide what % of sales those top customers represent for each location and overall company. A customer can be top ranked in one store, or multiple stores. Is there a way to do a TopN function in Phocas, either in custom mode or thru some built in function I’m overlooking? ---
**Author:** ![nicolas.servouse](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/nicolas.servouse/32/50_2.png) [@nicolas.servouse](https://pug.phocassoftware.com/u/nicolas.servouse)\ **Post date:** [June 29, 2021, 1:27pm UTC](https://pug.phocassoftware.com/t/topn-rank-calc/1909/2 "2021-06-29T13:27:32Z")
Hi @Mike have you tried the following: 1. Create a matrix for the stores and customers: 1.1 Go to the stores dimension, highlight your stores and click on matrix 1.2 Go to the customer dimension 2. Change the Format button (Displaying “Actual”) to % share? Kind regards ---
**Author:** ![Mike](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Mike](https://pug.phocassoftware.com/u/Mike)\ **Post date:** [June 29, 2021, 2:52pm UTC](https://pug.phocassoftware.com/t/topn-rank-calc/1909/3 "2021-06-29T14:52:27Z")
Hi Nicolas Thank you for the suggestion. That method works well when I want to manually sort for the topN (lets use 25) in each location. I’m looking for a way to do this dynamically, and in summary for dashboarding/kpi purposes. For example: Store “A” had sales last month totaling $10M. The top 25 customers for Store A (ranked by sales last month) totaled $6.5M, or 65% of sales. However, Store B’s top 25 might only represent 45% of its sales. Also, Store B’s top 25 would likely be a completely different list of customers than Store A’s list. The only way I can do this today (that I know of) is to nest location/store by customer (or visa versa), export to Excel, and then using a series of pivot filters and functions. Unfortunately, that means it can’t be summarized in a Phocas Dashboard. ---
**Author:** ![lina.tamkunaite](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/lina.tamkunaite/32/473_2.png) [@lina.tamkunaite](https://pug.phocassoftware.com/u/lina.tamkunaite)\ **Post date:** [July 1, 2021, 12:36am UTC](https://pug.phocassoftware.com/t/topn-rank-calc/1909/4 "2021-07-01T00:36:08Z")
@Mike another work around is this: 1. select the top 20 → Right click → exclude selections 2. Click on cogwheel and tick the box called “show others”. It will now show you your top 20 as “others” (and you will get % of all) and then all the rest. you can then turn it into a pie chart. The only limitation is that it can’t be dynamic - you will have to select your top 20 every month (once the month is over). This way might still be quicker than download into excel and pivot. Hope this helps. ---
**Author:** ![Mike](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Mike](https://pug.phocassoftware.com/u/Mike)\ **Post date:** [July 1, 2021, 12:56pm UTC](https://pug.phocassoftware.com/t/topn-rank-calc/1909/5 "2021-07-01T12:56:56Z")
Thanks @lina.tamkunaite , I’m really looking for a way to dashboard the results. To your point, the top 20 would have to be manually filtered each month. Plus, I can’t find a good solution for the variation in customers by location. I would have to create a separate top 20 for each location. I will add this to the product suggestions section