Aggr() Rank Buckets in Pivot Table

[#1]

Hi Qlik Community

I am currently endevouring to solve the following:

I would like to create a 4x4 matrix (pivot table) with, in one dimension, the rank according to one score, and on another the rank according to another score WITHIN the buckets in the first dimension. I need this because the scores are highly correlated, and I would like to have 16 equal sized buckets. I figured that the pivot table would take take of this, but it takes the rank according to the entire population in the second dimension. Is there a way to restrict the ranking to only the bucket defined in the first dimension? I've provided an example QVW below.

[#2]

Whoever can answer this will be my hero! This is the last step I have to creating an efficient app. Right now I have a solution but it uses ~100 nested if statements!