Quiz

  1. 1
    Advanced

    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
    Advanced

    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
    Advanced

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