COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS PowerPlay => Topic started by: rajivgupta1107 on 22 Jun 2009 01:38:05 AM

Title: conditional count in powerplay cube
Post by: rajivgupta1107 on 22 Jun 2009 01:38:05 AM
hi
I want to compute a count of column depending upon the value of it.
example : sum(if column value='Y' then 1 else 0)
So how can i compute in cube?

Similarly I want a count of column having value as 'N'.


Regards