Grouping in crosstab column

[cmanlok]

Hi, I am new to cognos.
I have a problem on how to group several columns as "OTHERS" in crosstab header

E.g:
              AU    UK    HK   JP  TH   CN
Apple     21    45     50   40  30  20
Orange  79    20     10   10  15  20

I want to group HK, JP, TH and CN as OTHERS

              AU    UK    OTHERS
Apple     21    45     140
Orange  79    20     55

Is that possible to do that?
THANKS!!!!             

[MFGF]

You could do this in a query calculation:

if ([Your column] = 'AU' or [Your column] = 'UK') then ([Your column]) else ('Other')

Cheers!

MF.