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.
