I'm sure I'm missing something simple, but the Rank function is giving me a tie when the data clearly shows that there isn't a tie. Any help is greatly appreciated!! Below is the formula and a screenshot of the output.
This formula seems to work if I only look at "VENDOR_ID" and "RANK" in a table or matrix..etc..
But if I add "Vendor Name" or "State"...any other possible slice to show more info..then rank is no longer valid. Is there a way to make it dynamic so if I add another piece of data to it..it won't cause an issue.
Ultimately..I would like to have "Rep, Market, Vendor Name, and Rank" in one visual.
It's almost like it will only allow a rank of one item...so I can rank by Rep..or I can rank by Market..etc... But if I have it ranking Market..and then just add the rep's name to the visualization...then it blows up.