I have a table with 3 dimensions and 5 measures, simples.....
One of the measures is REVs and I want to rank each entry in the table across all three dimensions, which I thought would be very simple, I have added the following calculated expression into the table:
This results in an answer, but the answer makes no sense to me whatsoever, the first entry is rank 1 at 15,000,000 REVs but the second entry is also ranked 1 when the REVs are 14,398,000. Somewhere in the middle of the rank 1's is an entry for Rank 2 at 4,269,722 REVs and below that it goes back to rank 1 at 3,861,855 REVs.
Any clue as to what I'm doing wrong here, I'm about to lose what little sanity I have left.
