This content has been marked as final. Show 2 replies
I am attempting to use Rank in a straight table and it is not working correctly.
This is an example of my two data tables
|Group Name||Company Name|
|Group 1||Company A|
|Group 1||Company B|
|Group 2||Company C|
|Group 3||Company D|
|Group 3||Company E|
|Group 3||Company F|
So I then set up a straight table that looks like this
My Rank formula is rank(Money), it is only ranking the one group that only has one company under it. Is there a way to fix this?