A B C D F G H I L MN 0 P Q R Write a formula in the yellow cells that looks up the Game Platform in column B and the Launch Quarter in column C and applies the quarterly phasing % based on the tables in JS:P21 to the Total Fiscal Year Revenue in column D. Feel free to manipulate the tables/data however you see fit. 2 Q1 Revenue Q2 Revenue Q3 Revenue Q4 Revenue Q1 13% Q2 15% 20% Q3 50% 50% 80% Xboxo Game Platform Others One PS4 Oh Others Xbox One PS4 Xbox One PS4 Launch Quarter Q3 Launch 03 Launch Q3 Launch 02 Launch 02 Launch 02 Launch Q4 Launch 04 Launch Game Platform 1 Xbox One Q1 Launch Q2 Launch Q3 Launch 04 Launch Total Fiscal Year Revenue $ 10,000,000 $ 23,000,000 $ 20,000,000 $ 8,000,000 $ 16,000,000 $ 17,000,000 $ 3,000,000 $ 1,500,000 Q4 Total 22% 100% 30% 100% 20% 100% 100% 100% 02 Q1 10% Game Platform 2 PS4 Q1 Launch Q2 Launch Q3 Launch Q4 Launch 17% 20% Q3 55% 55% 85% 04 18% 25% 15% 100% Total 100% 100% 100% 100% Q1 12% 5 Game 6 Assassin's Creed 7 Assassin's Creed 8 Assassin's Creed 9 Far Cry 10 Far Cry 11 Far Cry 12 Just Dance 13 Just Dance 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 20 29 30 31 32 Game Platform 3 others 01 Launch Q2 Launch Q3 Launch 04 Launch Q2 16% 18% Q3 54% 53% 82% 94 18% 29% 18% 100% Total 100% 100% 100% 100% 34 35 Part 2 Part 3 Part 1 Raw Data Part 1 Part 1 Pivot + Enter OP W 4. MacBook Pro 512 DI F8 0 F7 000 ODO F4 . F6 80 F3 510 F9 F5 FI F2