COGNOiSe.com - The IBM Cognos Community

Hi everyone,

in report studio i want to create tow columns using query items defining in framewokr manager (count distincct id)=>numberSales

colunmns 1 : calculeted item : total (case wen country = 'USA' then numberSales else 0 end )
colunms 2 :  total (case wen country = 'USA' then numberSales else 0 end )
Results :
col1                      col2
20 0000               0
0                         50 000
But i want this :
col1                       col2                   
20 000                   50 000