Hi, I was wondering if there is anyway to reorganise columns when they are based on values in an attribute. I have a chart with the headers below but I need Parts to sit in from on MAT

Looking at your pivot table, you want to reorder the column attribute values so that PARTS appears before MAT. GoodData's column ordering in a pivot table is driven by the underlying attribute values and their sort configuration. Here are the options available to you: Option 1: Sort by a Label in the Data Model You can control the order of attribute values by defining a sort label on the attribute in the Logical Data Model (LDM). This lets you sort by a specific label in ascending or descending order. However, this only supports A→Z or Z→A ordering — it won't let you place PARTS arbitrarily before MAT unless that order happens to match an alphabetical or numeric sort. [Sort Labels] Option 2: Use a Sort Column in Your Data Source You can define a separate column in your database table that assigns a custom sort order (e.g., numeric rank: LABOUR=1, PARTS=2, MAT=3, OTHER=4). Then in the modeler, click the ⋯ button next to the attribute, select Sort by…, and choose that ranking column. This gives you full control over the display order. [Sort Labels] Option 3: Multi-column Sorting in the Pivot Table UI GoodData also supports multi-column sorting directly in the pivot table, but this sorts by measure values within columns, not by reordering the column attribute values themselves. [Multi-column Sorting] In summary, to get PARTS to appear before MAT, the most reliable approach is Option 2 — adding a sort-order column to your data source and configuring the attribute to sort by it in the GoodData modeler. There is no drag-and-drop reordering of column attribute values directly in the UI. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups. 👀 Our Support team monitors all messages and will jump in if needed.

Hi Chris, please try out these recommendations from our AI and let us know if you need any further help.

Ill have a look, it would be a good feature to be able to just drag and drop them though as we might need different orders on different charts