We have a report where we have subsummaries sorted by product type, some metrics about each product, and these are sorted by stores. For instance:

PRODUCT MONTHLY SALES

Store 1:

A 14

B 2

16

Store 2:

A 3

B 25

C 1

29

I need a grand total for all stores, *sorted by product,* like this:

All stores:

A 17

B 27

C 1

45

But all I can get is a grand total of all products, all stores, like this:

All Stores:

45

Can anyone explain how to go about this? I'm so thankful for this community- it has helped greatly in the past!

subsummaries can be sorted by different fields, but it sounds like for "all stores", you need a leading or trailing grand summary part. These parts will summarize the entire found set when you drop a summary field in.

So usually reports layout parts are in this order for what you're saying:

- Subsummary (sorted by store) <-- will display the sum of all items for that store

- Subsummary (sorted by product) <-- will display the sum of all items for that product

- Trailing Grand Summary (no sort required) <-- will display the sum of all items in found set