Merged Explores on Dashboard Not Exporting as CSV Correctly

[Jen_K]

So I have built a merged pivot table (with table calculations) for a co-worker that is part of a dashboard.

The point of the dashboard is to have a single starting point for my co-worker who needs to update & pull the new CSV files each month. They are just going to be editing the ‘site id’ filter each month. 

When looking at the dashboard, everything looks just as it should. 

dashboard view

But when I “Schedule Delivery” of the CSV zip file the data is out of order thus impacting the table calculations. 

same tile as seen on dashboard view

Has anyone else seen this issue? Or know of a fix? Thanks.

EDIT - I am not having this issue with any of the tiles on the dashboard created from single looks/explores.