Minimum and maximum values
In this example, you'll need to find the Minimum and Maximum Budgets for films in each country.
You'll need to add Budget to the Values section twice, with the first one showing the minimum value, and the second one showing the maximum value.
この演習はコースの一部です
Google Sheets のピボットテーブル
演習の手順
- Add
Countryto the Rows section to list all of the countries. - Add
Budgetto the Values section twice, and select the proper calculations. Make sure that the minimum value appears first, followed by the maximum value.
