Contributor

Export functionalities

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.

Capture.PNG

 

But the requirement is need to be show as followes

1111.PNG

 

Kindly suggest me on this.

 

Regards,

Mahesh

3 REPLIES 3
Community Boss

Re: Export functionalities

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

Highlighted
Contributor

Re: Export functionalities

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. 

New Contributor

Re: Export functionalities

Hi Mahesh,

 

Please follow these steps to export.

Step 1 :  Pivot Dimensions into ROW and COLUMN.

clipboard_image_0.png

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

clipboard_image_1.png

 

Step 3: Go to Grid Layout

clipboard_image_2.png

 

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

clipboard_image_3.png

Step 5 : Export Results as you want

 

clipboard_image_4.png

 

Hope, It will help you.

 

Thanks and Regards,

Naushad