Add the ability to Pivot on the Resource ID

Feature Request: Pivot Grid Support for Resource ID

Summary:
Enable the Pivot Grid to include and aggregate on Resource ID so users can analyze BOE Pro data at the individual resource level. This will allow teams to pivot, filter, and report on metrics tied directly to each resource’s associated idea.

Problem Statement:
Currently, the Pivot Grid does not support Resource ID as a field. In BOE Pro, every resource has an associated idea, but users cannot pivot on that relationship. This limitation makes it difficult to answer resource-centric questions (e.g., performance, workload, or impact by resource) and forces users to rely on manual exports and spreadsheets. The lack of Resource ID in the Pivot Grid reduces the value of existing idea and resource data because it cannot be easily analyzed within the system.

Proposed Solution:
Add Resource ID as a selectable dimension/field within the Pivot Grid so users can:

• Include Resource ID as a row, column, or filter in pivot views.

• Group, sort, and aggregate data (e.g., counts, totals, averages) by Resource ID.

• Combine Resource ID with idea-related fields (e.g., idea status, type, or owner) to create richer resource-centric reports.
  Ensure that Resource ID is available wherever other core dimensions are available in the Pivot Grid configuration UI. The feature should respect existing permissions and data visibility rules so users only see resources and ideas they are authorized to view.

Benefits:

• Enables resource-level analysis directly in the Pivot Grid, reducing reliance on external reporting tools.

• Improves visibility into how resources are tied to ideas, supporting better planning and decision-making.

• Saves time by eliminating manual data exports and spreadsheet manipulation.

• Increases the value of existing BOE Pro data by making resource–idea relationships easily reportable and actionable.