Set column order when new columns appear

[AMERINO]

I think that the question has an easy solution but I have not found the answer already.

I make a monthly report, it looks like this:

Seller	# Customers	2018.01 Sales	2018.02 Sales	Accumulated Sales	Accumulated Orders	Accum. Customer Visits
Agent A	500	9000	7500	16500	2800	3700

I want “monthly sales” after “number of customers” and before “Accumulated Datas”. But every month, when I create the new report, the “new month sales” appears in the last column so I have to move it manually every time.

Seller	# Customers	2018.01 Sales	2018.02 Sales	Accumulated Sales	Accumulated Orders	Accum. Customer Visits	2018.03 sales
Agent A	500	9000	7500	24500	4100	5500	8000

Is there any way to order columns automatically? And avoid to do it manually every month.

Thanks in advance!

[WilliamR · Accepted solution]

Hi,

can you try this ?

The Dynamic select allow to split column based on the name in 3 parts, and you append the column with the append field.

[santhosh · Accepted solution]

I hope this help. Thanks

Regards,

Santhosh

[santhosh]

I hope this helps. Thanks

Regards,

Santhosh