Period format in export file.
Hello, I am saving some export definitions for my client. To print all the codes in a flat .csv export file, I would have to put 4 or 5 dimensions in the rows, but it's limited to 3. Instead, I am using the tabular method with a filter for time and version.
The only problem is that when time is transposed Anaplan changes the format of the time from 'Q1 FY20' to 'FY20Q1'. So to work around that, I've put the period in a line item. But now I have the time dimension showing FY20Q1 and the line item printing 'Q1 FY20'. Why is Anaplan changing the format of the time? Is there a way to get it to export it right so I don't have to put it in a line item? See file attached.
Thank you for your feedback,