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!!!!
You could do this in a query calculation:
if ([Your column] = 'AU' or [Your column] = 'UK') then ([Your column]) else ('Other')
Cheers!
MF.