Issue in Tabular Multiple Column Export Format

[CommunityMember131357]

Hi All,

I am facing an issue while exporting data from a dashboard by selecting Tabular multiple column export option. Although the table on the dashboard has been published by creating a saved view(i.e. by selecting 'Show Selected Line Items only' option). However, while exporting the data in tabular multiple column(.csv) format the other line items which are not visible on the dashboard or the saved view are also getting retrieved.

Further Information: The grid view format retrieves the desired line items only but do not suffice the user purpose.Hence a solution is required around tabular multiple column export format and the data can also not be retrieved in(.xls)  format as it shows too many rows error therefore it can only be obtained (.csv) format.

Please help me around this.

Thanks

[YukieM]

Hi @CommunityMember131357 , I also encountered this issue however looks like this is how export works. Here we can find out how export works. https://help.anaplan.com/en/98017f9d-8fb9-4143-8420-5c4ed33c883b-Export-from-Anaplan If you look at "Module and dashboard export options" you can find out what supported options are and this situation "Show/hide or data filter with only line items on columns" there is no check with Tabular Multiple Column which means it is not supported. Once I tested this with additional items on columns (so line items is not the only item on columns) I got expected result (only filtered data was exported)

[Soumyajaiswal]

Hi, 

But how do I apply any filter to the view? I am facing an issue where I am applying filter - having the filter line item in different module with same dimensionality. And can not add those filter line items in the same module as I don't want them in the Export. So how do I apply the filters?

[ryan_kohn]

@Soumyajaiswal You can apply a filter to a tabular multiple column export in the configuration of the export. The filter can be in another module, but the line item needs to share the same dimensions as the module you are exporting from. See here for more info: https://help.anaplan.com/e6151196-8b4a-46de-a18f-59338c3ff6b0-Export-filters.

[Anilkumarch]

Hi @CommunityMember131357  you need to recreate the export action if you have changed the ealier saved view. If the export action is not recreated then the export will have the line items as per previous saved view.