We love to hear your feedback. Your suggestions and ideas are important to us. Our feedback forum is a great place to post your ideas and vote on others. Please share your detailed use case and how the proposed enhancements can increase value to your business. We do read all of your posts, but may not be able to respond to all comments.
More information on the status of submitted ideas can be found here
Hi Swati, ER's report templates functionality may help with this. You can set up a template and use Excel's 'FILTER' function to automatically filter your data to the correct category. You can visit the Enhanced Reporting: Templates article to see how it works.
Note: The 'FILTER' function isn't directly supported within ER report templates — you may see '_xlws.' prefixed to the function name, which can cause errors. To avoid this, you'll need to use a macro in your template to insert the 'FILTER' function into the worksheet at runtime.
have you tried a reporting template?