Translations:Basic Excel/220/en

Create additional pivot tables

Create two additional pivot tables as follows:

PivotTable2

  • Base this one on the named range 'AIData2'.
  • Place it on a separate worksheet.
  • Use it to determine how many seropositive and seronegative samples there were in each sub-district.
  • Name the worksheet PivotTable2, and move it to the end of the workbook.