1. 1

    You have a PivotTable with Categories on rows, and two instances of Sum of Amount in the Values area. How would you convert the final column to show as follows?

  2. 2

    The following PivotTable is configured with Dates on rows, Class on columns and Amount in the Values area. What kind of difference did the author use to create the Diff columns in this PivotTable?

  3. 3

    If you configured a difference and one of the cells in the PivotTable showed a #NULL error, how would you approach this?