Hello,

I am wanting to create past utilization reports on users based on available hours vs hours logged in timesheets for the same period.

I know that I can "hard code" a few queries that will provide specific periods, i.e. 1. Query for Year-To-Date utilization, 2. Query for Quarter-To-Date utilization, 3. Query for Month-To-Date utilization, etc.

However, I would like to have one generic query that populates a user's available hours in a column of a pivot table (next to the each respective user).  The available hours would then update based on a date user filter.

NOTE: I already have figured out how to compensate for different hire dates (using hire dates from Zoho People).

I can't figure out how to change the Available Hours (which is a calculated field based off dates), based of a date user filter.

Any help would be appreciated.