Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Groups selected data together and performs a calculation on the group.

Group by

Specifies the property by which you want to group.

Options

Opens the Options dialog box where you can specify how the grouped data is displayed.

Subtotals

Specifies the calculations you want to perform on a group. To specify a calculation for a property, select the appropriate check box. The Count calculation is available for all properties. The remaining calculations, such as Total, can only be performed on numerical properties.

Note: The subtotal calculations are performed on the rows actually displayed in the report and will not include information for any duplicate rows that are excluded from the report in the Options dialog box.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×