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.
Latihan ini merupakan bagian dari kursus
Pivot Table di Google Sheets
Instruksi latihan
- 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.
Latihan interaktif langsung
Ubah teori menjadi aksi dengan salah satu latihan interaktif kami
Mulai latihan