If you are unable to create a new account, please email support@bspsoftware.com

 

Group by unsing define query items (count distinct) in framework don't work

Started by WILLA, 27 Apr 2016 11:41:56 AM

Previous topic - Next topic

WILLA

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