how to export pivot to multi excel or multi sheets files with multi filter

Hello,
 
Thank you for your question.
 
We would like to kindly inform you that the current version of Flexmonster does not provide a possibility to export different pivots to separate sheets of the same excel file.
 
As for exports according to the filter values in the pivot, it can be difficult to implement applying multiple filters and exporting them to Excel within the same instance of Flexmonster. Check out an example we have prepared, demonstrating two sequential exports with different filters applied.
 
However, as a workaround, our team recommend using an approach based on creating a new instance of the component with new filters applied, execute an export from it and remove the created instance.
 
We are looking forward to hearing from you.
 
Best regards,
Illia