Export data to .csv file from a module with page selector and filter is not working
Exporting data to CSV file from a module with page selector and filter is exporting incorrect results:
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: