Pivot Table excel downloaded file reordered columns/rows

Support - Assistance technique
1

Hi, there is one problem in 2.40.6 when I download an excel from Data Visualizer pivot table, it reorders my file columns and rows to alphabet, not in the style of my own.

2

Hi

Could you please explain how the change happens? Is it after you import the file into spreadsheet or before? Are you able to reproduce this issue in any of the play.dhis2.org instances.

Thanks!

5

Hi

image
image1654×1054 106 KB

Look at the above snapshot; there I have my own order for the first column. But when I download it to an Excel file, it changes the order to alphabetical. like the below snapshot.
image
image1035×855 57 KB