Export functionalities

UMAMAHESH
UMAMAHESH
in Modeling

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

Tagged:

Best Answer

  • DavidSmith
    DavidSmith
    Answer ✓

    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

Answers

  • akhil.kohli
    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
    naushad786

    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

Categories