Hi All,
I have the below tables
| Region | Revenue |
|---|
| North | 100 |
| South | 200 |
| East | 300 |
| West | 400 |
| Department ID | Revenue |
|---|
1 | 200 |
| 2 | 300 |
| 3 | 400 |
| 4 | 75 |
| 5 | 25 |
I'd like to create a table that has just the name of the Dimension and the max % of Revenue for that dimension and the Dimension value that is the max such as below
| Dimension | Max Revenue Share | Dimension Value |
|---|
| Region | 40% | West |
| Department ID | 40% | 3 |
Does anyone have any ideas?
Thanks,
Mark
