Percentage of rows
Let's look at a selection of films released in various languages over several years. You'll need to calculate the percentage of Gross Revenue that can be attributed to a certain language in each year. For instance, in 2010 there were films released in French, Hindi, and Spanish, totalling $30M of Gross Revenue. What percentage of that $30M can be attributed to each language.
You will not need to add any additional fields to the pivot table editor for this exercise.
Ця вправа є частиною курсу
Зведені таблиці в Google Sheets
Інструкції до вправи
- Modify the options for
Grossso that the data in the pivot table is shown as percentages for each year. (Each year should add up to 100%). You may need to change the number format to show the data as percentages.
Практична інтерактивна вправа
Перетворіть теорію на практику за допомогою однієї з наших інтерактивних вправ
Почати вправу