Can columns in Pivot table be rearranged ?

Mike Ronzio

My column data for the pivot is the number of items completed in a month. The column heading are the months but when I first create the pivot table, the months are not in calendar order. If I move the columns so that the months are in calendar order, will the date be refreshed into the correct columns ?

Genevieve P.

Hi @Mike Ronzio

Yes, after the initial workflow run which created the Pivot sheet, you can both re-name and rearrange the order of the columns. The next update will still refresh the appropriate columns as these are synced by the column ID, versus location or title. (See: Organize and Format the Pivot Sheet)

Cheers,

Genevieve

Genevieve P.

Hi @Mike Ronzio

Yes, after the initial workflow run which created the Pivot sheet, you can both re-name and rearrange the order of the columns. The next update will still refresh the appropriate columns as these are synced by the column ID, versus location or title. (See: Organize and Format the Pivot Sheet)

Cheers,

Genevieve