Within the PowerPivot Data Model editor, you can also filter the data that is returned to Excel through the filtering option.
NOTE: This is part of the Using PowerPivot to Analyze Your Dynamics AX Data blog series where we show how PowerPivot can assist you with advanced data analysis and reporting, making those extracts from Dynamics AX to Excel even more valuable. If you want to see all of the other posts in this series, click here.
HOW TO DO IT
To can add a filter to a table in your data model, follow these steps:
- Select the drop down from the heading of the field that you want to filter on and you can either manually select the field values to filter on, or you can click on the Filters options to create a rule.
- If you create a filter rule then you will be able to update the filter conditions through the Custom Filter dialog box.
HOW IT WORKS
After applying the filter you will only see the data that matches.