Export data to .csv file from a module with page selector and filter is not working

Hi,

Exporting data to CSV file from a module with page selector and filter is exporting incorrect results:

Sample Data

as per my example below, Anaplan is applying the filter (amount<>0) to the first month March 23 only. Zero's are getting exported for the intersections data available in first month (filter is not applied to April 23 month)

Also, filtering out the data from April 23 month for which no amount in March 23 (first month or ) e.g. P4-A3-Apr 23 - Amount $90 from original data is not exported. Anyone facing this issue?

One of the option is to change to saved view so that Product, Account and Period/month are in rows. But ~7 million records are getting exported with this, locking users every time we run export action.

We dont want to export zero amount rows or blank cells.

For the example in the screenshot and attachment, we expect rows after export is:

Expected Result:

Export_from_saved_view_with_filters.xlsx

Thanks,

Esa

Accepted answers

All comments

andrewtye

Hi @ENurubasha

Might be worth raising this with Support. I've done something similar out of one of our models and the export is functioning as expected ie per your excel picture of the zero combos being excluded.

Andrew

ENurubasha

Thanks @andrewtye

Can you please share the saved view, filter and export data that you did. Want to make sure i am having same filter, saved view as yours.

Thanks, Esa

andrewtye

Hi @ENurubasha

Hmm - this is odd, rebuilt the table from scratch and I put in some values from that are in month two and not month one. Those are now not coming through as the export. Whereas it was working fine last week.

Definitely feels like it's a support call to understand if that's the expected behaviour for exports. I know that Tabular Modular are very picky about how it works.

Andrew

Quick Links

Can you help?

Unanswered questions

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
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.…