PowerPivot has another great feature that allows you to create relationships between tables so that you can report off both tables within the same query.
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.
Where PowerPivot starts to really outshine the simple Pivot Tables is in the feature that allows you to create new columns through the PowerPivot Manager. You can then filter, and report off the results as if it were a normal field in the system.
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.
PowerPivot has a couple of extra features that you can take advantage of while you are building your dashboards for slicing and filtering your data. One is called a Timeline Slicer.
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.
PowerPivot gives you all of the capabilities that the Pivot Tables have, plus more. With PowerPivot you can create pivot tables and charts, and also dashboards with multiple panels showing that use the same data source.
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.
At one point or another, everyone has probably used Pivot tables within Excel to slice and dice information. PowerPivot is an extension of this functionality, so it makes sense to initially show how this works before showing all of the new features that are available within PowerPivot.
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.
Extending Dynamics AX 