Hi All,
I have master table where all employee are ranking to different physical fitness (like Exercise, Diet, Running etc.). with rank=1 as very low and 5 as very high.
My requirement is that I need to calculate percentage of rank based on category and sub-category. As the data are not present is proper order, I am not able to proceed it. How can I do it. can you please help me.
The category and sub-category will be assigned like below
Variable Category subcategory
Exercise Fitness1 Fit1
Diet Fitness1 Fit1
Running Fitness1 Fit2
jogging Fitness2 fit1
playing Fitness2 fit4
swimming Fitness3 fit1
riding Fitness3 fit1
dancing Fitness3 fit1
sleeping Fitness3 Fit5
Attaching sheet for your reference
Bookmarks