U.S. Office of Personnel Management - Ensuring the Federal Government has an effective civilian workforce

Contents

• Exploring Reports (Overview)
  • Explore Data
    1. Choose Categories (change rows and/or columns)
    2. Choose Measures
    3. Find Specific Dimensions or Measures
    4. Drill Down and Drill Up
    5. Filter Data
    6. Nest Categories
    7. Replace Nested Categories
    8. Hide Totals and Subtotals
    9. Perform Calculations
    10. Hide Data While Exploring Your Report
  • Format Data
    1. Choose a Display (Crosstabs/Charts)
       • View a Chart and Table Together
    2. Show Report Values as Percentages
    3. Sort Values
    4. Swap Rows and Columns
    5. Limit the Size of Crosstabs
    6. Suppress Values
    7. Hide Categories
  • Export Data
    1. Export Data in CSV File Format (Excel)
    2. Export Data in PDF Format (Adobe Acrobat)
    3. Prepare a Bookmark
    4. Print Reports