How to do sequential filtering for rankings

Hi guys!    I have a dimension table of Assets, and I'm doing a three-step ranking filtering, being that after each rank filter the number of assets analyzed is restrained.   I created independen...