Total in Crosstab queries

[dbadmin]

Hi,

I have a crosstab query which gives me an output like this

CUST_ID REC_NUM COUNT1 COUNT2
100 00 3 3
100 01 2 3
101 01 2 3
102 00 0 1
103 00 1 0

Can I have a total of the counts in another column with the same crosstab query?

CUST_ID REC_NUM COUNT1 COUNT2 total
100 00 3 3 6
100 01 2 3 5
101 01 2 3 5
102 00 0 1 1
103 00 1 0 1

 

[dbadmin]

I got the answer. Thank you any way.

dbadmin

 

[Therese]

What was the answer?