Average and median
In this example, you'll need to find the Average and Median values for Gross Revenue each year.
You'll need to add Gross to the Values section twice, with the first one showing the average value, and the second one showing the median value.
Latihan ini merupakan bagian dari kursus
Pivot Table di Google Sheets
Instruksi latihan
- Add
Release Yearto the Rows section to list all of the years. - Add
Grossto the Values section twice, and select the proper calculations.
Latihan interaktif langsung
Ubah teori menjadi aksi dengan salah satu latihan interaktif kami
Mulai latihan