Here is an ‘oldie but a goodie’ from our original site that we’ve had people ask for often. This is more relevant for Microsoft Office 2003. These can be used nicely with all our ERP packages including:
- Microsoft Dynamics NAV (Navision)
- Microsoft Dynamics AX (Axapta)
- Microsoft Dynamics GP (Great Plains)
- Microsoft Dynamics SL (Solomon)
- Sage MAS90, MAS200, MAS500 (MAS 90, MAS 200, MAS 500)
- SAP Business One
PivotTable Reports 101
Let’s suppose you’ve compiled a large list of data – for example, sales figures for every product your company makes. But now you’re ready to distill some meaningful information from the data. For example, you might want to answer the following questions:
· What is the total sales for each product by region?
· Which products are selling best over time?
· Who is your highest-performing salesperson?
For these and other questions, you can create a PivotTable® report – an interactive table that automatically extracts, organizes, and summarizes your data. You can then use the report to analyze the data – for example, make comparisons, detect patterns and relationships, and analyze trends.
Read on to discover what you can do with a PivotTable report.









