Customize and Use Your Pivot Table

Various customization options:

  • Rename the headings
  • Change the color, font, theme, chart size, spacing, etc.
  • If you don’t have more than one category on the rows side, give your Pivot any ascending or descending sort
  • Choose to hide or show your totals
  • View underlying data
  • Follow the paths used in report creation to verify the right lookup relationships