Forum Discussion
Custom sort based on another value that has contain many blanks
Hi there
would like to seek your help to geting sort the visual with these data
This is the visual that i want to sort based on the value of MCI
This is the reference data
| Senior_VP | MCI Count |
| Aaron | 1 |
| Amanda | |
| Balaji | |
| Christine | |
| Christopher 1 | |
| Christopher 2 | |
| Duane | |
| Gregg | |
| James | 9 |
| Jennifer 1 | |
| Jennifer 2 | |
| Jordan | |
| Joshua | |
| Juliette | |
| Maria | 1 |
| Mike | |
| Muhammad | |
| Ramiya | 3 |
| Sharon | |
| Srikanth | |
| Susan | |
| Trung | |
| Usman | |
| Vivek |
i hope you can help me with this
1 Reply
replace the blanks with an appropriate value (for example 0 ). Add a small random number to break ties.
