Need help

[#1]

Hi All,

My requirement is as below

I have a review done by for each resources by Internal and External for few categoires. The resources are rated based on each Category on a scale of 1 to 10. if rating value is NA which means the resource has not been rated for that category and should not be considerd for calculation. For example Name1 has been rated for 3 Categories

Condition 1: The resources would be considered as Excellent by Internal if only rating for all the categories for which he is rated is >7

Condition 2: The resources would be considered as Excellent by External if only rating for all the categories for which he is rated is >7

If the resource is EXCELLENT in both Internal and Extrenal over all valid Categories , Then the resource will be considered as Overall Excellent

I just want to create a chart which will tell me total no of resources and how many of them has overall as Excellent . The chart should have 3 columns

Any dimension , Total No of Resources for that dimension and Total no of Overall Excellent Resouces. I have attached a sample data for the reference

[sunny_talwar · Accepted solution]

May be like this?