RANK with Selective Access
I'm trying to build a module that displays only the top ten cost centers based on a variance line item that I've got calculating. I'd gotten it to work with a RANK formula and then a boolean line item, but then when I started trying it with selective access set up on the cost center, it broke and I only see a few of what should be the top ten items based on my more limited access. It appears that the rank still calculates on all the expense centers (even the ones I don't have access to).
Does anyone have any workarounds for this?