We are experiencing a pivot issue in both the Desktop and Web versions of Axpert Report. The default pivot feature is not displaying the data in the desired order. For instance, we need our 'Total' column to appear either as the first or last column in the report. While it displays correctly in the SQL query, the Axpert pivot does not maintain this order. I've attached a screenshot for your reference. Please assist us in resolving this issue.
Solution:
