How to work out average for two cycles
Hello, seek for help! Sample data for two cycles (Jan to June and July to Dec): comp A, jan to jun, proj L, score 80, rating 1 comp B, jan to jun, proj L, score 70, rating 2 comp A, jul to dec, proj L, score 70, rating 2 comp B, jul to dec, proj L, score 84, rating 1 comp A, jan to jun, proj K, score 65, rating 3 comp A, jul to dec, proj K, score 50, rating 4 comp C, jan to jun, proj K, score 45, rating 5 comp C, jul to dec, proj K, score 55, rating 4 Q1: Average score of respective companies. Q2: Average rating of respective companies regardless of project names. comp C be shown when press rating 5 at slicer. A will be under rating 3 (average of 80+70+65+50=65). comp B will be shown under rating 2. results i got - comp A shown under rating 1,2,3,4 Q3: Number of projects under respective companies