Forum Discussion

rcorn's avatar
rcorn
Frequent Visitor
3 years ago

RANKX value changes for filtered value when it shouldnt

I am using a RANKX formula to rank a category by UPB($). As shown in the screenshot I have two tables, the first table with only the green highlighted category with the rank 8, and the second table w...
Need Help
rcorn's avatar
rcorn
Frequent Visitor
3 years ago

Thanks for the response, ALLSELECTED will not work in this case as it limits ranking to only the green category in the first table showing rank 1 where I want it to continue to show correct rank of 7 (as shown in table 2)

PeterChen's avatar
PeterChen
Helper I
2 years ago

Having same issue.... Have you solved it?