Translations:Basic Excel/217/en
Specify pivot table structure
Our objective for our first pivot table is to determine how many samples were tested each day, by subdistrict and village. Note that Excel will automatically attempt to sum outputs that it sees as numeric, but will count items if a text field is put into the 'Nilai' box. As we wish to count the numbers of samples, we will use any of the fields containing text in 'Nilai' (please experiment to see the effects of using different choices). Move the fields by dragging: