Grouping rows
In this example you are going to be looking at the Budgets for every film within the dataset. You'll need to determine how many films fell into specific ranges of budgets. For instance, how many had a budget of $0 - $50 Million; how many had a budget of $50 - $100 Million, and so on.
Это упражнение является частью курса
Сводные таблицы в Google Sheets
Инструкции к упражнению
- Create a Group Rule using an interval of 50,000,000. You can leave the Min and Max at their default settings.
- This is one option that is not found in the pivot table editor; instead, you'll need to right-click somewhere.
Практическое интерактивное упражнение
Превратите теорию в практику с помощью одного из наших интерактивных упражнений
Начать упражнение