Editing the column ordering in a Dashboard Pivot table | XM Community
Skip to main content
Question

Editing the column ordering in a Dashboard Pivot table


Is anyone familiar with how to change the display order of columns in a pivot table dashboard? for some reason, the months are showing in a random order rather than in sequence. there does not seem to be an option to reorder them. I can do this in most other widgets but the Pivot table sees to be different. Does anyone know how I can achieve this?

3 replies

ana_velez
QPN Level 5 ●●●●●
Forum|alt.badge.img+27
  • QPN Level 5 ●●●●●
  • 284 replies
  • June 26, 2019
Hi! are you displaying the months from a date or from a text value with the name of the month?

Hi Ana, I am having the same difficulty. When using Text Value the sorting is alphabetical as opposed to month order. Based on your question above, in Dashboard settings I created the same month field using 'Date' format. But this resulted in no data being displayed at all in my pivot. Would you have any additional suggestions please?

Forum|alt.badge.img+1

I have the same question -- trying to figure out how to sort columns in a pivot table on a dashboard...