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.
Практична інтерактивна вправа
Перетворіть теорію на практику за допомогою однієї з наших інтерактивних вправ
Почати вправу