The ability to see FTEs on the pivot gride.

Feature Request: FTE Metrics on Pivot Grid

Summary:
Enable users to view and analyze Full-Time Equivalent (FTE) data directly in the pivot grid. The pivot grid should support FTE-based calculations (e.g., allocated FTE, remaining FTE, total FTE by project/role/period) so users can quickly understand resource utilization and capacity without exporting data or performing manual calculations.

Problem Statement:
Today, the pivot grid does not expose FTE metrics, forcing users to estimate or calculate FTEs outside the system (e.g., in spreadsheets). This makes it difficult to understand true resource utilization, compare FTE demand vs. capacity, or roll up staffing views across projects or time periods. As a result, capacity planning and staffing decisions are slower, more error-prone, and lack a single source of truth.

Proposed Solution:
Introduce FTE-related fields and calculations as first-class metrics within the pivot grid:

• Add FTE data as available measures (e.g., Allocated FTE, Available FTE, Remaining FTE, Total FTE) that can be added to pivot values.

• Support FTE aggregation by common dimensions

• Ensure FTE values are derived consistently from underlying allocation or hours data (e.g., based on standard hours per FTE) and respect existing configuration for calendars and work schedules.

• Ensure performance remains acceptable when FTE calculations are enabled on large datasets.

Benefits:

• Provides a single, reliable view of FTE utilization directly within the pivot grid.

• Reduces manual calculations and external spreadsheet work, lowering the risk of errors.

• Improves capacity planning by making it easy to identify over- or under-utilized resources.

• Enhances decision-making for project staffing and prioritization through clear, aggregated FTE insights.

• Saves time for project and resource managers by streamlining a common analysis workflow.