COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: masha2008 on 16 Dec 2008 01:40:29 PM

Title: Help with TOTAL
Post by: masha2008 on 16 Dec 2008 01:40:29 PM
This has to be my output

Customer        TBD         LM       TO

12345             45           20        34
25643             7               8         9

TBD, LM, TO comes from the same column, so I create a Data Item = 'TBD' and how do I count how many TBD's per customer.

Thank you

Title: Re: Help with TOTAL
Post by: JGirl on 16 Dec 2008 11:08:13 PM
You could use a crosstab, with your measure either count(<column>) or count(distinct <column>) depending on what your requirement is?
Title: Re: Help with TOTAL
Post by: SFU on 17 Dec 2008 02:45:27 PM
Check below kb on cognos
KB 1033352.2
How to total a measure for members from different dimensions.

Thanks.