Idea Summary
Interactive Report Pivot currently orders generated pivot columns based on the pivot value display order, which may be alphabetical rather than business/logical order.

Add a declarative option in Interactive Report Pivot to define the ordering of pivot column values, for example:
- ascending/descending by display value
- order by hidden sort column
- order by SQL expression
- manual/custom order

This would make Interactive Report Pivot more usable for period-based, fiscal, budget, forecast and timeline reports.

Use Case
When pivoting accounting periods such as APR-2025, FEB-2026, JAN-2026, the generated columns should follow chronological order, not alphabetic order. Developers should be able to define an order-by expression or a separate sort value for the pivot column values.