Quick Pivot Tables

• I grabbed the data on Crime in NYC from here
• Note, the next file is very big, and might take a while to download:
  • It is very big, so I cleaned it up (some) and it is here
• Click in the table
  Click on the INSERT tab and the Pivot Table button.
  • Put Jurisdiction in the Filters area
  • Put Borough in the Rows Area.
  • Put Offence in tht collumns area.
  • Put Offence in the Values area.
  • What does this show?
  • Can you show crimes by Jurisdiction by Month?