Give the user the Pivot Filter User role

1. Click on Work Hierarchy
2. Click Users
3. Find the user you want to give access to
4. Scroll to the bottom of the form
5. Click the "New User Roles" button on the related list
6. In the role field search for "Pivot Filter User" and select it
7. Click the Create button

The user will now have the Pivot Filter on their left nav and the ability to run the report.

The pivot report allows you to report and filter on every record type on the work and user hierarchy.

For a user to see the Columns and Filters for a specific record type (i.e., Departments) they have to have access to the filter on the Pivot Filter and access to the table (they might already have this from other roles i.e., the base Timesheet User role gives read access to all of the Work Hierarchy).

In the example below we are going to give a role access to report on Departments.

1. Create a new role
1. Creating a Role
2. You can also use an existing role
2. Click on Access from the left navigation
3. Click on Roles
4. Find the Role you want to give additional access to
5. Scroll to the bottom of the Role form
6. Click the "Security Level" tab
7. Click the "New Security Level" button
8. In the table field pick "Departments"
9. Click the "Create" button
10. Check the "Read" checkbox in the "Table Access" section
11. Check the "Read" checkbox for at least one column in the "Field Access" section
12. Click "Save"