Excel Pivot Table

 
  Microsoft Excel includes a feature called a Pivot Table that allows users to design their own reports.  

Note: Each supported version of Office (97, 2000, 2002/XP) behaves a little differently and has some different features.  Discussed here.

By allowing users to select which 'fields' they would like to have on rows and columns a Pivot can be used to view the data in the way that makes most sense to the user: 

 
If you don't like what you see it can be changed with a simple drag and drop to change the row and column data.

SIGNZ uses Pivot Tables to interface with the SIGNZ Data Warehouse, providing quick access to data.  However, using the Pivot Table reports (and Pivot Charts) requires a reasonable knowledge of Excel and users can easily be mislead by 'filters' being placed on the data.  For non-technical users, or those wanting to view the same report types, often we recommend using SIGNZ DWreports.