Hi Team, can this table be sorted in GD from latest to earliest, with the quarter displayed as Q4 2025, Q3 2025, and so on? 64. NSW Quarterly Ranking - GoodData Cloud

Yes, this is achievable in GoodData! Your pivot table is showing Quarter/Year as column headers, and you want them sorted from latest to earliest (e.g., Q4 2025 → Q3 2025 → … → Q4 2017). Here's how to do it: Sort Columns Chronologically (Newest to Oldest) 1. In Analytical Designer, open the visualization. 2. Click the Sort icon on the filter bar. 3. Set the date/quarter column sort to Newest to Oldest (descending chronological order). This will reorder the Quarter/Year columns from the most recent quarter back to the earliest. [Sort Data in Visualizations] > Note: For chronological sorting to work correctly on quarters, you must be grouping by Quarter (not a custom text attribute). If the Quarter/Year values are coming from a GoodData date dimension grouped by Quarter, chronological sorting is supported out of the box. [Sort Data in Visualizations] Multi-Column Sorting (Pivot Tables) Since this is a pivot table, you can also sort directly from the column headers: • Click a column header to sort by that column (replaces existing sort). • Shift-click additional column headers to add them to a multi-column sort. • Use the ⋮ header menu on a column to set sort direction. [Multi-column Sorting] If Quarter/Year is a Custom Text Attribute (Not a Date Dimension) If the Quarter/Year column is stored as a text string (e.g., "Q4 2017") rather than mapped to a GoodData date dimension, chronological sorting won't work automatically. In that case, the recommended approach is to add a numeric sort-order column in your data source and configure it in the GoodData Modeler via Sort by. [Sort Labels] The cleanest solution is to ensure your Quarter/Year is mapped to a proper date dimension in your logical data model, which will give you full chronological sorting support. 👍 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 Cathy, let me clear a few things up as the support AI got a bit confused here. The sort button described in the documentation is actually only available for a few selected visualizations: bar charts, column charts, area charts, combo charts, bullet charts, pie charts, donut charts, and heatmaps. Pivot tables do not have this option. This is actually more of a product feedback request as there isn't a way to easily change sorting like this by date column on the table. Could you provide some details as to how important this type of feature is for your business use case? We can then provide that information to our product team to assess further.