Extended grid aggregation capabilities

Important

This content is archived and is not being updated. For the latest documentation, go to What's new or changed in Finance and Operations apps home page. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Users by admins, makers, or analysts Aug 1, 2022 Oct 1, 2022

Business value

Users can get additional insight into tabular data by showing other aggregation functions for columns in grids.

Feature details

This feature extends the current totals feature in the grid by allowing users to choose one of four aggregation functions for each numeric column. In addition to showing a total, grid columns can now be configured to show the minimum value, maximum value, or average value in the column. If grouping has been performed within the grid, the chosen aggregation function for that column will be shown for each group.

Important dates

These dates represent the current targets for this feature as it progresses toward becoming mandatory for all customers. The dates are subject to change.

Feature stage Version Date
Generally available 10.0.29 October 2022
On by default 10.0.32 April 2023
Mandatory 10.0.36 October 2023

Customers grid with the Credit limit field configured to show average values

See also

Grid capabilities (docs)