Topic Options
#51939 - 12/08/16 01:24 PM Gridview Report
CarlosC Offline
Adagio Fan

Registered: 03/21/08
Posts: 31
Loc: North Bay, ON, Canada
Hello,

I am trying to create a gridview report that totals certain categories by salesperson.
The columns I need are:

SalesPerson, (Cat 951+952), (Cat 953,954)

Is this possible to combine different categories on the same line?
I tried using calculated columns to check if the category is one of the two options and add the Amt but when I summarize by SP the calculated columns are not summarized.

Any help would be much appreciated.

Thanks.

Top
#51942 - 12/08/16 02:31 PM Re: Gridview Report [Re: CarlosC]
Bruce Gardner Online   content
Adagio Wizard

Registered: 06/15/04
Posts: 3611
Loc: Toronto ON, Canada
Carlos:

If you right-click on the title of the calculated column(s), is there a check-mark on "Display Total"? You need a check-mark there to see the totals in when subsequently summarize the View.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#51943 - 12/09/16 07:02 AM Re: Gridview Report [Re: Bruce Gardner]
CarlosC Offline
Adagio Fan

Registered: 03/21/08
Posts: 31
Loc: North Bay, ON, Canada
Hey Bruce,

I clicked that check box and now everything works the way we would like it. Thank you very much Bruce.

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 78 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14448 Topics
70593 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30