rank total with aggr is still calculating on selections
i was able to make good progress with y'alls input to refine this calc, but i am still beating my head against the wall with this calculation involving rank(total aggr( ; it keeps referencing the visible results on straight table. . . any help would be greatly appreciated. as a note, the calcs in the middle work as expected. probably staring at this too long.