9.4 Using the Pivot Grid

The Pivot Grid gives you the ability to visually analyze data according to combinations of variables.

  1. From the Dashboard, click Load from Database.

  2. Browse to select the file system scan you want and double-click it.

  3. Click Pivot Grid.

  4. From the Pivot Fields region, select Size (residing in the Measures folder) and drag it up to the area marked Drop Data Items Here.

  5. Again in the Pivot Fields region, select Owner and drag and place it in the area marked Drop Row Fields Here.

  6. Observe the totals now calculated for the two data variables.

  7. From the Pivot Fields region, expand Access Time to locate Access Time (Year) and drag it up to the area marked Drop Column Fields Here.

  8. Click the filter icon from the Access Time (Year) filter that you just placed.

  9. Deselect all but the last three years and click OK.

  10. Click the Chart tab.

  11. Highlight three consecutive rows to view the data analyzed as graphs in the Chart region.

  12. From the Chart Presets options, experiment with different chart views of the data.

  13. Double-click a selected cell from the table to access the Scan Data Details table specifying all of the files accessed by that user during that year.

  14. From the Scan Data Details table, right-click a file and select Open Folder to open the parent folder of the file.

    With the parent folder open, you can examine the file, move it to another location, or delete it.

  15. Click the Reports tab.

  16. Again, highlight three consecutive rows.

  17. Click Generate Report.

  18. Observe that you have the option to print the report or export it to a number of different formats.