AnsweredAssumed Answered

How does one sort a grand total?

Question asked by vtdonn on Dec 13, 2018
Latest reply on Dec 13, 2018 by philmodjunk

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! 

Outcomes