Quiz

  1. 1
    Advanced

    You have the PivotTable shown below and want to display the percentage of the category compared to the grand total for each row of the table. How would you do it?

  2. 2
    Advanced

    You’ve got a PivotTable set up with Years on rows, Class on columns, and Sales $ on values (twice). Both Sales $ columns are currently set to aggregate as a Sum, but you’d like to display the second column as a % of the previous year, as shown below. What do you need to do?

  3. 3
    Advanced

    While we often display a basic aggregation with our “% of” measures, it’s not entirely necessary. Assuming you have the following PivotTable with Categories on rows, Class on columns and the default Sum of Amount on values, how would you convert it to show as follows?