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.
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.3
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,