I have been looking around and could not find something to recreate. I am trying to find the Top Performing Customer (corporation) based on Total Sales Measure. I have pasted a sample data of the table I am working with (of course there is more data)
Anyways I am trying to show the top performing account managers followed by the distinct count of corps they are working with, followed by the total sales, then the top performing CORP(customer) by sales.
I have completed everything but the top performing customer. I was wondering if anyone has performed this already.
| Date | Year | Month Num | Month Nam | YYYYMM | AIRLINE | POS | CORP | INDUSTRY | POS FULL | Contract type | Dest | ACCT MANAGER | Contract? | Class | Sales | Type | Meassure Sales | Meassure Type |
| 7/7/2016 0:00 | 2016 | 7 | Jul | 201607 | DL | MX | Jet engines inc | Computer Software | MEXICO | (EPL-01) | Mexico | John Does | Y | Economy | 0 | 0 | 0 | 0 |
| 4/4/2016 0:00 | 2016 | 4 | Apr | 201604 | UA | MX | The chemical company | Chemicals | MEXICO | (EPL-01) | Mexico | Mike Smith | Y | Economy | 500 | 1 | 0 | 0 |
| 8/8/2016 0:00 | 2016 | 8 | Aug | 201608 | AA | MX | The chemical company | Chemicals | MEXICO | (EPL-01) | Mexico | Mike Smith | Y | Economy | 600 | 1 | 0 | 0 |
