In order to use the plugins please login as a Guest
Page tree
Skip to end of metadata
Go to start of metadata

Calculate the average, minimum and maximum rating in each group:

  1. Select the value Group in the Row labels input.
  2. Leave the Column labels input empty.
  3. Remove the value Group and select the value Average rating in the Calculated column input.
  4. Select the value Average in the Operation type input.
  5. Add the value Max in the Operation type input.
  6. Add the value Min in the Operation type input.
  7. Click the  icon and Save changes.

80 %

Training table

Student's progress sheet

Oops, it seems that you need to place a table or a macro generating a table within the Pivot Table macro.

The table is being loaded. Please wait for a bit ...

StudentGroupAverage ratingAdmission to the exam
Diana LyndonGroup 17(minus)
Quin RichGroup 35(minus)
Clint PamilaGroup 28(plus)
Andy AsiaGroup 14(minus)
Primula LinnieGroup 39(plus)
Leith EireannGroup 26(minus)
Mary SaxonGroup 18(plus)
Robina CletisGroup 35(minus)
Allyn ArloGroup 110(plus)
Dave BertieGroup 39(plus)
Matty LowellGroup 210(plus)
Sheridan AnselmGroup 26(minus)
Kemp EmmetGroup 28(plus)
Sarah MillyGroup 19(plus)
Anna KassyGroup 27(minus)

  • No labels