Ranking Project - One Category at a time
Hope you are having a great day so far!
I have a requirement to rank projects based on specific criteria of Profits from each of them. However, they need to follow a specific order to be considered for Ranking specified below-
a. Mandatory Projects should be ranked first based on their individual profits
b. Government Projects should be ranked after Mandatory Projects
c. Rest of the projects should be Ranked after ranking Mandatory and Government projects
Ranking should happen based on Projects but it has to be done for a specific category of projects first and then move to the next category of projects