Export functionalities

UMAMAHESH

Hi Experts,

I am trying to export Module.

In the Module Row Axis have:Product list Column Axis:Line Items Page axis :Time,Customer

When i try to export the module .CSV format. The data showing in excel like as followes.

Page selector dimension members showing top of the sheet.

But the requirement is need to be show as followes

Kindly suggest me on this.

Regards,

Mahesh

Accepted answers

DavidSmith

You can pivot the module, and save as a view to nest the dimensions and export as desired, or also, look at the different export types: Tabular Single column, or tabular multi column

David

All comments

DavidSmith

You can pivot the module, and save as a view to nest the dimensions and export as desired, or also, look at the different export types: Tabular Single column, or tabular multi column

David

akhil.kohli

You can achieve this by having the time in the rows as well, and making a view out of it (Best Practices) and using one of the export types to export it in the desired format. Max you can have 3 dimensions in rows/ columns respectively. So this is easily achievable.

naushad786

Hi Mahesh,

Please follow these steps to export.

Step 1 : Pivot Dimensions into ROW and COLUMN.

Step 2 : Select to show only "Apr 19" and "MT" and Saved View

Step 3: Go to Grid Layout

Step 4: Go to Labels and check "Include Label Headers"

Step 5 : Export Results as you want

Hope, It will help you.

Thanks and Regards,

Naushad

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…