Feature Spotlight: Pivot Tables in Agriware Business Central
Struggling with complex reports and Excel exports to understand your data? Our Analysis Mode transforms how you view list pages in Business Central, replacing cumbersome processes with intuitive, customizable tabs and pivot tables. Whether it’s inventory, sales, or orders, get the insights you need — fast
Analysis Mode
The analysis mode offers a different way to view data on list pages. Instead of running reports with various options and filters, you can easily add multiple tabs that represent different tasks or data views. Examples include "Batch inventory per location," "Planned batches per week," "Sales statistics," or any other desired view.
How it works: Viewing batch inventory
Open the standard batch list in the role center. Normally, this displays a flat list of all batches, possibly filtered. However, this doesn’t yet provide a convenient inventory overview. You could copy the list to Excel and sum it up there, but that’s no longer necessary! Open Analysis Mode to get started.
The analysis view now opens, allowing you to customize the layout as desired. In the example below, you can see how the current inventory per crop, per location, can be displayed in a simple pivot table. The data can be expanded to view details.
Pivot Table
Another insight that’s easy to create is the expected availability per period. By activating Pivot Mode, you can create a true pivot table.
Save and Share
Once you have the basics, you can endlessly vary your insights. It’s very convenient that you can save views for later use. This way, you can create your own overviews in no time, and you’ll have the information you need quickly available from now on.
You can also share the views with a colleague, who can view the overview once or save it for next time. Super handy.
All List Pages
This functionality works on all list screens in Business Central. This means you can also create overviews of your customers, items, sales orders, and work orders!
