Description:
Flex Grid currently lacks the ability to customize sorting for each entity in rows or columns in the layout. Although the misalignment issue on custom/standard time entities was resolved in the latest 14.3 release, there is still no functionality to control sorting behavior at the entity level—unlike in Data View.
Proposed Enhancement:
Enable per-entity sorting options in Flex Grid, including:
• Ascending / Descending order
• Sort by Code or Description
• Sort by Block Order (as defined in the layout/configuration—entity, algorithm, or cube driven)
Example Use Case:
When three entities (Scenario, DHPQtr, and DHPMonth) are placed in columns, users should be able to configure:
• Scenario → Block order (from layout)
• DHPQtr → Description (Descending)
• DHPMonth → Code (Ascending)
Benefits:
• Aligns Flex Grid with Data View sorting capabilities, ensuring a consistent user experience.
• Provides greater flexibility for ad hoc analysis without requiring layout rebuilds.
Note:
This idea builds upon the resolved sorting misalignment in 14.3, shifting focus toward user-level sorting controls within Flex Grid.
