D365 Platform Update 33 Preview: It Groups!

The preview release of Platform update 33 for Finance and Operations is now available (general availability is scheduled for March). This is part of a series highlighting features in the new platform update.

It Groups!!!

Grouping brings some pivot table-like functionality to D365 grids. Similar to how numeric columns can be totaled, non-numeric columns can be grouped. Right click on the column and select “Group by this column”

Posted Project Transactions, Grouped by Project Name

Posted Project Transactions, Grouped by Date

Save Groupings as Views

Once grouped, these new grid layouts can be saved as views.

Grouping is a promising UI experience. In the Platform Update 33 preview, users are able to group on a single column. Future plans include the ability to group on up to five different columns, expand/collapse groupings, and group subtotaling.

If You Still Really Want a Pivot Table

If you find yourself in need of the full pivot table experience, remember that grid data can still be downloaded to Excel.

Ctrl+Shift+E, Enter

Our D365 hotkey to download data to excel.

Alt+N+V, Enter

Our Excel Hotkey to build a pivot table.

Then select your fields as desired.

Best of luck, my Excel power-user friend.

additional reading
What’s New Platform Update 33
Grid Capabilities
Grouping With Subtotals in Grid

1 thought on “D365 Platform Update 33 Preview: It Groups!

  1. Pingback: Using Project Categories | iamJoshKnox

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s