Help with TOTAL

[masha2008]

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

[JGirl]

You could use a crosstab, with your measure either count(<column>) or count(distinct <column>) depending on what your requirement is?

[SFU]

Check below kb on cognos
KB 1033352.2
How to total a measure for members from different dimensions.

Thanks.