aggr function

[alec1982]

hi all

I have a table that looks like

ID     Category     Sub Category     Count

1     A                    AA                         20

2     A                    BB                         60

3     B                    AA                         25

I need to add in a chart a column that show the total of each category so my table chart will look like

ID     Category     Sub Category     Count     Sum

1     A                    AA                         20          80

2     A                    BB                         60          80    

3     B                    AA                         25          25

Anyone knows the trick?

[sunny_talwar · Accepted solution]

May be this:

Sum(TOTAL <Category> Count)

UPDATE: I guess Count is an expression, but the idea is to use TOTAL qualifier with the field on which you want to total on. So use your current expression for count and add TOTAL <Category> in there and you should be good.

[sunny_talwar]

Here is a sample to look at